Jun 22 2009

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

If you're new here, you may want to start with my most popular posts. Then, subscribe to my RSS feed to stay updated. Thanks for visiting!

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.

TAGS: ,

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sponsors

Recent Readers

JOIN MY COMMUNITY!
                  Computers Blogs - Blog Top Sites