Advertisements

SQL-BOX.COM

–SQL Server Storage

Tag Archives: secondary

How to bring a database online which is in restoring mode ?

For Example, In log shipping the secondary or a stand-by database will be in restoring mode while applying the logs from primary for every 15 minutes.

In order to perform a DR test, we need to bring the production down and DR database online, this can be achieved by running the below query on secondary server database.

–Run this below query to bring the database online which is in Restoring state after successfully restored all log backups using the restore jobs in secondary server

Restore Log [DATABASE NAME] with recovery

Advertisements
%d bloggers like this: