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

Cannot shrink log Expand / Collapse
Posted Tuesday, April 30, 2013 12:30 AM



Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 5,669, Visits: 11,173
Thanks Jeff for keeping it up.

Your list of suggested action is perfect, but I'd say it's a bit overkill for beginners.

To start - it's important to remember doing regular LOG backups apart from DB backups.
Then after the pattern of TRN usage over day/week is established then shrink TRN file to the apprpriate size.
Ideally - shrinking should be done by doing all the steps in your list.
Which never happens (apart of the databases I'm in charge of ).
Post #1447904
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse