In SQL Server 2008, I have a mirrored database with a log file that has increased to 80GB, which is not normal and I have serious problem. I would like to decrease the log file size by truncating it.
My database is in Full Recovery Model. Backups for both database and log file taken every day. My database is mirrored to a mirror SQL Server. My database has active connections. I have read so many articles and opinions but still I cannot decide what I should do in order to truncate log file without consequences.
Should I turn to simple recovery model and truncate?
Should I stop mirroring, do what I should do to principal database and then enable mirroring?
Should I create a new log file to another disk?
I have read so many things but I am really confused. Could someone give me a hint how should I cope with this problem?