Error: Object reference not set to an instance of an object.
説明
Error may display similarly: Executed as user: PROD\login_name. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:07:14 PM Progress: 2008-10-20 12:07:17.61 Source: {DFDCF8CE-F56C-42D3-923F-1F2A47DA50A3} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2008-10-20 12:07:17.91 Code: 0x00000000 Source: Back Up Database 1 Error executing LiteSpeed. Description: Object reference not set to an instance of an object. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:07:14 PM Finished: 12:07:17 PM Elapsed: 3.719 seconds. The package execution failed. The step failed.
原因
LiteSpeed Maintenance Plan includes a database that has been deleted.
対策
STATUS: Fixed in a future version of LiteSpeed.
WORKAROUND: In 5.0.1.1060 there was no possibility to make the plan work if one of selected databases has been deleted. The only way is to recreate the plan. In 5.0.2 you need just to edit the plan, open Back Up task, save it and then save the plan.
