bxcapo
asked on
SQL Server 2000 Database is in warm standy (Read Only) Mode
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
WITH RECOVERY