SQL Server Database stuck in Restoring state
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
- 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.



