SQL Server Maintenence Plan error on an offline Database

Posted by Sean Earp on Server Fault See other posts from Server Fault or by Sean Earp
Published on 2009-06-24T04:48:36Z Indexed on 2014/08/21 4:23 UTC
Read the original article Hit count: 430

Filed under:
|

Today is SQL day for me :)

I have a maintenance plan that is failing to run with the following error:

Failed:(-1073548784) Executing the query "USE [SharedServices1_DB]" failed with the following error: "Database 'SharedServices1_DB' 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.

where SharedServices1_DB is a database that is set to offline. I would like to exclude this database from the maintenance plan, but when the database is offline, it does not show up at all as a "specific database" in the maintenance plan task, and if I bring it online, it is already unchecked in the maintenance plan task.

How can I exclude an offline database from a maintenance plan?

© Server Fault or respective owner

Related posts about sql-server

Related posts about Maintenance