Tuesday, 1 March 2011

Got a SQL DB stuck in restoring?

Then use the following script:

RESTORE DATABASE [DATABASE NAME] WITH RECOVERY

Taken from
http://www.execsql.com/post/bringing-a-database-out-of-restoring-state-in-sql-server-2005

0 comments: