SQL Server Transaction Log Large & Simple Recovery Model - TechRepublic
Question
May 8, 2007 at 08:29 PM
garymac12

SQL Server Transaction Log Large & Simple Recovery Model

by garymac12 . Updated 19 years, 2 months ago

I have a database that is in Simple Recovery mode and yet the Transaction log is very large – over 1 Gb and larger than the database. There is no concurrent sessions. I ran Checkpoint. Is there any danger in truncating the transaction log after a full backup? BTW, auto shrink option is NOT selected in the database options.

This discussion is locked

All Comments