I am having 2 servers( namely Server 1 and Server 2) based on Windows Server 2008 R2 where SQL server 2008 R2 Enterprise edition is installed.
I am having 2 SQL databases that are mirrored from Server 1 to 2. e.g. at a given point of time say, Server 1 database is Principal and Server 2 Database is mirrored. The mirroring is in automatic fail over mode with the help of a Witness Server.
These 2 databases are huge w.r.t to transaction and in a day, one database is having almost 4000 rows added in it.
I have facing the issue of huge volume of .ldf file which is causing the designated disk for SQL filled very frequently.
Frequently we need to stop mirroring, take backup and delete the .ldf file.This is a troublesome job.The volume of .ldf file is almost 230 GB and .mdf file volume is 28.7 GB.This causing great inconvenience to the database maintenance staff.
Is there any way to solve this issue so that,.ldf file volume can be less and require very less manual intervention for delete the same by stopping mirroring , take back up and delete the files.