Database Mirroring and Log File Size
Posted on 2009-05-10
I have setup database mirroring and noticed after few days that the size of Transaction Log is around 180 GB. The max size is set to around 203 GB. this way I am soon gonna run out disk space.
Can somebody please help me on how to shrink the transaction log where database mirroring is setup. I have another database on the same server with database mirroring and the log file for that server is fine no probs.
Cannot understand why with this database the log file is increasing like anything ?
Thanks in advance.