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
sql-server
|Maintenance
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