Post reply

Logshipping & last t - backup

  • June 26, 2015 at 5:54 am

    #299517

    After we disabled the all the backup jobs in logshipping before failover

    How to apply the last t-backup to the read (stand by) mode that we take manually on primary

  • June 26, 2015 at 6:20 am

    #1808371

    RESTORE LOG MyStandbyDB

    FROM DISK = '\\MyServer\MyShare\MyFolder\MyFile.bak'

    WITH RECOVERY

    John

  • June 26, 2015 at 7:42 am

    #1808401

    You can also do the same by exeucting Restore backup job. After that recover database.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply