Post reply

Database is Synchronizing & Log Backup

  • January 30, 2014 at 1:43 am

    #303523

    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

  • January 30, 2014 at 2:33 am

    #1684563

    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

  • January 30, 2014 at 4:24 am

    #1684587

    @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.

  • January 30, 2014 at 4:57 am

    #1684591

    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

  • January 31, 2014 at 8:22 pm

    #1685268

    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