Home Forums SQL Server 2008 SQL Server 2008 High Availability SQL server 2008 R2 frequent transaction log full and my database is a mirrored one. RE: SQL server 2008 R2 frequent transaction log full and my database is a mirrored one.

  • November 30, 2017 at 11:08 pm

    #1970215

    Emil B - Thursday, November 30, 2017 6:21 AM

    what is your backup strategy? how often do you take transaction log backups?

    At present we normally do the above mentioned steps once in 5 days.We backup transaction log only when we see that the disk is going to get full.
    We can take backup in every 5 days.And keep the backup in separate location.