Post reply

Question on backup of sql database

  • June 30, 2011 at 9:07 pm

    #1346842

    GilaMonster (6/30/2011)

    Please go and do some reading on log shipping, log backups and restore sequences.

    Reinitialise as in recreate the log shipping secondary the same way you did when you first set the log shipping up.

    Re backups, you need to back the log shipping primary up. You can run full and diff backups. You just cannot have another job as well as the log shipping one that backs up the log.

    sorry about it.... i did some read up on basic log shipping, log backup and restore sequence.

    But just to confirm, in other words, you were saying if you configure that database for logshipping, you should not be doing backup for that database? Or we should not be doing transaction log backup for this database but only do full and differential backup? thanks

  • July 1, 2011 at 1:13 am

    #1346888

    GilaMonster (6/30/2011)

    Re backups, you need to back the log shipping primary up. You can run full and diff backups. You just cannot have another job as well as the log shipping one that backs up the log.

    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 - 31 through 31 (of 31 total)

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