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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center