Database is Synchronizing & Log Backup

  • Dear,

    When the principal database is in "synchronizing" state and then I take a log backup. What would actually happen?

    Do I need to restore that log backup to the mirror database or not? Please let me know.

    Thanks

    Akbar

  • Same things that happens any other time you take a log backup, nothing special.

    I wouldn't try restoring the log unless you're doing the initial setup of the mirroring

    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
  • @Gila Monster,

    Thanks for your help. I have already configured database mirroring. So, its not a new setup.

    Actually I took a log backup of principal database when it was on the "Synchronizing" state. So I was afraid of whether it makes any difference with respect to "Synchronizing" and "Synchronized" state.

  • No difference

    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
  • GilaMonster (1/30/2014)


    No difference

    Thanks. That's Great!

Viewing 5 posts - 1 through 4 (of 4 total)

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