January 29, 2013

Bringing a database out of Restoring state in MSSQL

Sometimes happens that you restored a database and you forgot the recovery tick, and this leads into a database stuck in restoring state mode where you cannot execute any actions.


One of the ways to bring the database out of the restoring state is using the restore database command with recovery as follows:


RESTORE DATABASE <DATABASE_NAME>





WITH RECOVERY