SQL Database in Restoring State

microsoft sql server 2008
SHARE THIS:

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 © 2021 Unylogic Consulting Ltd.
TO TOP
arrow-upmenu-circlecross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram