![](http://photos1.blogger.com/blogger/3826/519/320/SQL.jpg)
Executing the query "BACKUP DATABASE [MyDBName] TO DISK = N'V:\\Backup\\Bak\\MyDBName_backup_200709120100.bak' WITH NOFORMAT, NOINIT, NAME = N'MyDBName_backup_20070912010042', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Database 'MyDBName' cannot be opened because it is offline.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The cause is an offline database when the Maintenance Plan is configured with "All Databases", thanks to Loris for troubleshooting.
I don't know if it's "by design" but I don't really like it !
0 commenti:
Post a Comment