How to get a Microsoft SQL Server 2005 Database Out of Standby/Read-Only Mod

Welcome back!

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.