SQL Database in Restoring State

By Bobby Ufot-Ekpo     Published on February 21, 2015

I encountered an issue where a SQL Database was in restoring state after a restore operation failed from SQL Management studio UI.

I used the following SQL Script to take the database back to operational state:

Script:

RESTORE DATABASE [Database Name]
WITH RECOVERY

Copyright © 2020 Unylogic Consulting Ltd.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram