Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Friday, November 20, 2015 12:04 PM
Points: 1,871, Visits: 3,520
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: Friday, August 28, 2015 11:12 AM
Points: 119, Visits: 938
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