Post reply

Mirroring database can take Tlog backup?

  • February 6, 2014 at 4:20 am

    #287987

    Hi,

    Database has been configured in Mirroring for high availabilty, Can we take Tlog backup on regluar intervel of time in principal database? what will happend transfer the data into mirror database? Tlog backup configured at every 15 min and log would be truncated.

    thanks

    ananda

  • February 6, 2014 at 4:24 am

    #1686525

    For a database to be mirrored, it must be in full recovery model. If you don't take log backups of a database in full recovery, your log will grow until it fills the disk.

    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

  • February 6, 2014 at 4:57 am

    #1686529

    if any impact of tlog backup on mirror database in prinicpal server? is the any issues logs truncated by tlog backup in principal database. so how truncated data will apply into mirror database.

    I noticed , there is one mirror wait stats (DBMIRRORING_CMD) 95 min always.

    Thanks

    ananda

  • February 6, 2014 at 5:07 am

    #1686531

    Well, as I said you have to take log backups, it's not optional (unless you want to run out of disk space). Since you have to take log backups when in full recovery, it would imply that mirroring works fine with log backups. Otherwise it would be pretty stupid of the SQL devs.

    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 4 posts - 1 through 3 (of 3 total)

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