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:SQL Parameter Sniffing — The REAL Fix Nobody Explains ProperlySQL: Use Computed Columns for Automatic Calculated ValuesSQL Server: Fix a Recursive CTE That Silently Stops Early Because of the Default MAXRECURSION Limit Views: 258