SQL Transaction logs
Posted on 2016-11-29
Have 2008 R2 SQL server. Had an issue over the weekend that caused the transaction log of one of the DB to fill up (DB is 6gb, Transaction log was 911gb!) I configured maintenance plan thinking after the full backup, those logs would be shrunk but they haven't, my recovery mode is set to full, I was thinking of setting to simple, shrink DB, and set back to full if that would clear the logs out. But shouldn't maint. plan be doing that?