Backup maintenance plan crashes when the number of databases selected individually is around 300.
Executed as user: SERVER\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:00:00 PM Progress: 2011-10-07 22:00:01.27 Source: {DF21A5A7-C1A8-49E3-9F49-04B87909AD79} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete End Progress Error: 2011-10-07 22:00:06.60 Code: 0xC002F210 Source: Back Up Database 1 Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint N'-D "database..." failed with the following error: "LiteSpeed maintenance plan failed. See SQL Server Error Log and SSMS View History for more details.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:00:00 PM Finished: 10:00:06 PM Elapsed: 6.281 seconds. The package execution failed.
The step failed.
After upgrading Litespeed from v5.x to to v7, Litespeed maintenance plans begins to fail intermittently. When they fail, they seem to write the file to the destination folder OK, but the job is beported as a failure. The error message in the job history and SQL error log is:
Source: {6ABCF282-0B15-4DF6-AA58-F43BF7896167} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete End Progress Error: 2012-07-18 06:00:26.68 Code: 0xC0024104 Source: Reporting task for-{34A234F6-B258-4076-852B-45FBB44E9309} Description: The Execute method on the task returned error code 0x80131500 (Failed to retrieve data for this request.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Warning: 2012-07-18 06:00:26.69 Code: 0x80019002 Source: DB Backups Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised
Product defect
WORKAROUND 1:
If backing up all user databases, then select the "User databases" option instead of specific databases.
WORKAROUND 2:
Use wildcards or regular expressions to filter the databases required to backup. Refer to help file on how to use wildcards/regular expressions.
WORKAROUND 3:
Split the maintenance plan into 2 or 3 plans dividing the number of databases accordingly.
WORKAROUND :
Delete the plan and create a complete new one.
STATUS
Waiting for fix in a future release of LiteSpeed for SQL Server.
