Thursday, May 24, 2012

How to bring the secondary database online in Log shipping?


In Log shipping by default the secondary database will not come online automatically if the primary database becomes un-available.During log shipping, the secondary database will be in Standby or No Recovery mode that means it will be available for Read-Only.

In order to bring the secondary database involved in log shipping to online we have to use any of below commands. These command are to be used in case the primary database becomes un-available either because of database corruption or database going offline or any other damage to the primary database.

Restore Database <Database Name> WITH Recovery

(or)

Restore Log <Database Name> WITH Recovery

Thanks!!!

1 comment:

  1. Thank you for the information. You have a very good article. I found it informative and useful. Keep up the good work and God bless!

    Yong
    www.gofastek.com

    ReplyDelete