I have several databases for my applications that use SQL Server 2005 mirroring to keep a nice copy of the data somewhere else. Works like a charm, however, the log file just seems to be growing and growing, one is at 15GB for a 3GB database.
Normally, I can just shrink it – however an error pops up that this specifically cannot be done. But, it seems eventually if unchecked would just expand to use all the space on the drive.
I see that I can set a maximum file size for the log file, is that the answer here? Will the log just roll when it hits the max, or will the DB just stop functioning?