How to attach database left in Standby mode
I have the .mdf & .ldf files for an old SQL 2000 database which I wish to re-attach to a different SQL 2000 server.
Using Enterprise Manager, I am able to attach the database in read-only mode. When I try to uncheck read-only access option, I get an error dialog with "Microsoft SQL-DMO (ODBC SQLState:42000)" as the dialog title.
The body of the dialog has 2 lots of "Error 5105: Device activation error", each complaining about "the physical file name" corresponding to the .mdf & .ldf as "may be incorrect".
It further complains that it "Could not restart database. Reverting back to old status. ALTER DATABASE statement failed. ..... sp_dboption command failed."
I have absolutely no idea what these all mean but I am guessing that the problem may be due to the fact that the old database appears to be in Standby mode, as opposed to being "Offline", i.e. when the old database files were copied, it was not brought to offline.
I really need to bring it out of read-only mode. Please help!!