Solved

SQL Server 2000 Database is in warm standy (Read Only) Mode

Posted on 2006-07-07
4
211 Views
Last Modified: 2008-01-09
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
Comment
Question by:bxcapo
4 Comments
 
LVL 12

Accepted Solution

by:
Einstine98 earned 250 total points
ID: 17061438
do a restore and leave the database fully operational
0
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 17061470
RESTORE DATABASE DatabaseName
   WITH RECOVERY
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now