SQL Server Database stuck in Restoring state
Posted by WorldofCode on Jul 22nd, 2010
2010
Jul 22
From time to time your sql database will get stuck in Restoring state. Here are two different ways to get your database out of restoring state.
RESTORE DATABASE MyDatabase
FROM DISK = ‘MyDatabase.bak’
WITH REPLACE,RECOVERY
or
- Stop the service (MSSQLSERVER);
- Rename or delete the Database and Log files (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data…) or wherever you have the files;
- Start the service (MSSQLSERVER);
- Delete the database with problem;
- Restore the database again.
View Similar Posts