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:Drag and Drop objects from Object Explorer to the Query Window in SQL ServerHow to find the first missing value in a series in MS SQLGet the User Name and Domain Name from an Email Address in SQLHow to create Local and Global Temp Tables in MS SQL Post Views: 193