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.
shekhar.mca
SSC Veteran
Points: 239
More actions
June 18, 2018 at 9:50 am
#1994314
Schedule(On principal server) a transaction log backup for the database in every 30 min interval and keep a tab on storage (Backup location).Ensure backup retention plan is in place to avoid high storage.