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

Cannot shrink log Expand / Collapse
Author
Message
Posted Tuesday, April 30, 2013 12:30 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, October 13, 2014 8:08 PM
Points: 4,573, Visits: 8,353
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