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:How to return only the Date from a SQL Server DateTime datatypeSQL 'string_split()' functionHow to create a single string from multiple rows in T-SQL and MySQLHow to create Local and Global Temp Tables in MS SQL Post Views: 208