Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

transaction log size reduction Expand / Collapse
Posted Thursday, March 28, 2013 1:50 PM


Group: General Forum Members
Last Login: Yesterday @ 11:07 AM
Points: 2,015, Visits: 3,810
MyDoggieJessie (3/28/2013)
If you haven't specified it during the initial install, it's set to 0 by default, meaning that it happens automatically (running approximately every 1 minutes for active DB's)

Reference MSDN here

Thanks, that is what I found, it is 0.
So the checkpoints commits approximately every one minute, that is quite frequent than I think.
Post #1436709
Posted Thursday, March 28, 2013 1:54 PM


Group: General Forum Members
Last Login: Monday, December 21, 2015 8:37 AM
Points: 119, Visits: 939
You said this database is Read Only?

If so, there should be no reason why you can't set it to Simple Recovery Model, then Shrink the Transaction Log file down to almost nothing, and I don't think it should ever grow again.
Post #1436714
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse