SQL Server 2000 Database is in warm standy (Read Only) Mode
Posted on 2006-07-07
I had to restore a database from backup. The database was successfully restored. However, it is in warm standby and read only. I tried going through Enterprise Manager, going into the Database Properties, and the Options tab to Uncheck the Read Only Option. I received an error message that the database was in a warm standby state, and could not be altered.
I tried executing the "Alter Database database name set read_write', command. It did not return an error, however, the database state did not change.
I need to know how to get the database fully functional again.