SQL Database stuck in “Restoring” state - 19.05.18 | 30.08.20 - ErcanOPAK You can use this command: RESTORE DATABASE <database name> WITH RECOVERY Related posts:Date and Time Conversions in SQL Serversp_help for SQL Server Management StudioFind numbers with more than two decimal places in SQLHow to clean Query and Execution Plan Cache for Efficient Testing in MS SQL Post Views: 209