You may get a similar error when a Maintenance Plan is executed:
Failed:(-1073548784) Executing the query "USE [NorthWind]
" failed with the following error: "Database 'NorthWind' cannot be opened because it is offline.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly
The database was removed after the Maintenance Plan was created.
Advance options for Select Databases are not supported for tasks except Back UI task
The problem is that Advance Options:
- Execute selected databases
- Order selected databases
- Ignore offline databases
are not available for other tasks except Back Up database.
For Check Integrity you will have the same selected databases but they are included.
Waiting for future release of LiteSpeed for SQL Server and will allow the user to select to "ignore offline databases" in other MP task besides backup. These would include Check Database integrity tasks, UPDATE STATISTICS tasks, and Reindex tasks.
The workaround until the new version is released is to recreating the plan each time a database is removed.
Also, see SOL56427, SOL40824
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center