Run this script;
RESTORE DATABASE [mydatabase] WITH RECOVERY
Resources;
https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/


Source, Ingest, Prepare, Analyze and Consume
Run this script;
RESTORE DATABASE [mydatabase] WITH RECOVERY
Resources;
https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/