Error: "The number of backup files in dump device has exceeded the limit of 2000" (23138)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error: "The number of backup files in dump device has exceeded the limit of 2000"
Description

Error: Executed as user: LiteSpeed 2005 Version 4.6.0.00293 Copyright (C) 2004-2006, Imceda Software Inc. All Rights Reserved. www.imceda.com .

P2-SQL01010 [SQLSTATE 01000] (Message 1) The number of backup files in dump device: \\<Servername>\<Location>\Caller_P2SQLabcde_LBack.LBAK , has been exceeded the limit of 2000. [SQLSTATE HY000] (Error 50274). The step failed.
Cause

This is because LiteSpeed has a design feature which includes a limitation of the number of times a file can be appended (the maximum number being 2000
Resolution

WORKAROUND:

Create a LiteSpeed Maintenance Plan that runs periodically which initialized that backup file and generates a new full backup file to be appended by the regular Maintenance Plan.
Additional Information

All verisons of LiteSpeed
All versions of SQL Server

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title