SQL 2005 Backup Error -1073548784

I experienced errors executing a Backup Maintenance Plan, the error code is -1073548784 and this is the error detail:

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 !
Tags: ,

About author

Vittorio Pavesi