RESTORE DATABASE [DATABASE NAME]
Taken from
http://www.execsql.com/post/bringing-a-database-out-of-restoring-state-in-sql-server-2005
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
RESTORE DATABASE [DATABASE NAME]
Taken from
http://www.execsql.com/post/bringing-a-database-out-of-restoring-state-in-sql-server-2005
Subscribe to:
Posts (Atom)