October 23, 2012 at 7:52 am
recently joined a firm and saw a maintenance plane created in lite speed.
steps involved are check database integrity,shrink database(system),backup database(system) and cleanup backup files older than XXX period.
the job is failing at last step since 3months.
error:
executed as user: . Microsoft (R) SQL Server Execute Package Utility Version ....... for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: xxxxxxx Progress: xxxxxxxxx Source: ...... Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: xxxxx Code: ....... Source: Clean Up Maintenance Plans 1 Execute SQL Task Description: Executing the query "exec master..xp_slssqlmaint N'-MAINTDEL -DELTYPE F..." failed with the following error: "slssqlmaint failed". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: xxxxx Finished: xxxxxx Elapsed: xxxxx seconds. The package execution failed. The step failed.
October 23, 2012 at 9:43 am
You sure its the last step failing??
Check the backup location and make sure any files are available for the maintenance plan to delete.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply