Post reply

Setup of a alternate DB server in different geographical location

  • December 20, 2016 at 7:43 am

    #316169

    I have a DB server which has log shipping enabled to secondary server with Tlog backup interval of 10 mins . We need to have another DB server ready in different geographical location. We plan to first move the Full backup and then Differential backup to the new DB server . My question is does the differential back affect the logshipping ? Also if i restore the Full backup plus all differential back in sequence will that be enough ?

    Looking forward to your suggestions . Many thanks in advance.

  • December 20, 2016 at 7:47 am

    #1918920

    You would restore the full, the latest differential (not all of them) and all log backups after that (leaving the DB in the RESTORING state), then set up the log shipping indicating that the secondary server has already been initialised

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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