Post reply

Log management in mirroring and replication

  • April 17, 2014 at 10:38 am

    #285881

    How does size of log remains in control in Mirroring as well as replication.I mean in log shipping there is regular log backup but there is no regular log backup in mirroring or replication.

    Plus does manual log backups breaks up mirroring.

    Second is it possible to log shipping and mirroring simultaneously.

  • April 17, 2014 at 11:04 am

    #1706870

    Since mirroring requires using the full recovery model you need to have scheduled periodic transaction log backups running to manage the size of your transaction log file. Without regularly scheduled transaction log backups, the t-logs will simply continue to grow until you run out of disk space.

    And yes, you can have log shipping and mirroring running on the same database at the same time. The log shipping will provide you with the regularly scheduled t-log backups.

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

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