Database stuck in Restoring state

Problem:

SQL Server database stuck in RESTORING state

Sometimes the database is in a restoring state after restarting the machine or for some other reason. It usually happens with big databases when a long transaction is in progress and an unexpected server shutdown or restart occurs.

Fix:

RESTORE DATABASE [MyDB01] WITH RECOVERY

Sources:

https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/