How to get a Microsoft SQL Server 2005 Database Out of Standby/Read-Only Mod
- 0 Comments
Google Query: SQL Server 2005 Database Standby / Read-Only
Recently, I helped a customer restore a SQL Server 2005 database. The only problem was that the default restore was leaving the database in Standby / Read-only mode. The solution to this problem was really quite simple. After some googling I came across this MSDN Thread.
Basically to restore the database from a backup and put it back into production mode, just run the following SQL query:
RESTORE DATABASE <database_name> FROM <full_backup> WITH RECOVERY;
Happy Database Restoring!
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.