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.

  • February 19, 2018 at 11:21 am

    #1980306

    anjang2k - Thursday, November 30, 2017 11:08 PM

    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.

    Not taking a transactional log backup for a database in Full Recovery model will make the log grow until the disk becomes full. You MUST have log backup schedule for the same at frequent intervals. Maintenance plans or agent jobs are good enough to do it. I didn't see any problem setting them up for a mirrored database. Just curious.