We just upgraded our Windows Server 2003\SQL Server 2005 setup to Windows Server 2012/SQL Server 2012. Both configurations have a mirror with NO witness server.
On the old setup the transaction logs remained small, about 22 GB total. Now they're over 160 GB and the partition of the new server is getting full. I need to reduce the transaction log file sizes.
However, all of the descriptions I've read say to switch the recovery mode from Full to Simple then back to Full. This won't work because we have a mirror so the recovery model MUST remain in Full recovery mode. I couldn't change recovery modes unless I break the mirror.
What would be the best course of action to reduce the log file sizes? Should I go ahead and break the mirror, switch from Full -> Simple then back? Does anyone have experience with this kind of setup?