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
Author
Message
Posted Thursday, March 28, 2013 1:50 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:54 AM
Points: 1,720, Visits: 3,063
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 1:07 PM
Points: 115, Visits: 902
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