Windows Server 2008 Thread, Shrinking MSSQL Log Files? in Technical; Hi guys,
What's the safest and best way to shrink MSSQL log files? One of our databases Log files has ...
23rd June 2011, 02:42 PM #1
Shrinking MSSQL Log Files?
What's the safest and best way to shrink MSSQL log files? One of our databases Log files has just hit 120gig and the HDD it's on is almost out of space!
24th June 2011, 10:05 AM #2
This may help:
sims ldf file nearly 17 gig
There's also a thread on here containing the code of the batch file
ETA - Here it is:
how to shrink an ldf file
Last edited by Gibbo; 24th June 2011 at 10:08 AM.
24th June 2011, 11:01 AM #3
I managed to get it sorted yesterday using something similar. I was worried I'd done something stupid but the SQL I used looked the same as the SQL in the batch file so I can sleep easy tonight
By Sam_Brown in forum Enterprise Software
Last Post: 5th July 2011, 09:29 AM
By soapyfish in forum Windows Server 2000/2003
Last Post: 23rd June 2011, 01:07 PM
By nicholab in forum O/S Deployment
Last Post: 11th January 2010, 09:19 AM
By googlemad in forum Windows
Last Post: 1st October 2009, 04:57 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)