0
votes
0answers
21 views

SQL Server 2008 log file growing and wont shrink. Hard Drive Space running out [duplicate]

I have a SQL Server 2008 database which has a log file (.ldf) with a size of 360GB and growing every day. The .mdf file is only 25GB. The hard drive is 950 GB and has 150GB free space. I want to ...
6
votes
1answer
2k views

Can I shrink the transaction log file on a mirror database?

This is a followup question to a previous question about why I couldn't shrink the log file on the principal database. To make a long story short, I setup database mirroring but forgot to make sure ...
6
votes
1answer
2k views

Transaction Log maintenance on Mirror database

SQL Server Version: 2008 R2 Enterprise SP2 I am trying to get a handle on our SQL Server maintenance and I came across something I think is incorrect. We have a single production instance with 3 ...