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.
bxcapoAsked:
Who is Participating?
 
Einstine98Commented:
do a restore and leave the database fully operational
0
 
Atlanta_MikeCommented:
RESTORE DATABASE DatabaseName
   WITH RECOVERY
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.