• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

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.
0
bxcapo
Asked:
bxcapo
1 Solution
 
Einstine98Commented:
do a restore and leave the database fully operational
0
 
Atlanta_MikeCommented:
RESTORE DATABASE DatabaseName
   WITH RECOVERY
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now