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

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[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.

Was this article helpful?

[Select Rating]

Title