+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    610
    Thank Post
    102
    Thanked 42 Times in 40 Posts
    Rep Power
    19

    Shrinking MSSQL Log Files?

    Hi guys,

    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!

  2. #2
    Gibbo's Avatar
    Join Date
    Feb 2008
    Location
    Cheshire
    Posts
    936
    Thank Post
    212
    Thanked 351 Times in 242 Posts
    Rep Power
    94
    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 11:08 AM.

  3. #3
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    610
    Thank Post
    102
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    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



SHARE:
+ Post New Thread

Similar Threads

  1. MSSQL Log Files are MASSIVE!!!!
    By Sam_Brown in forum Enterprise Software
    Replies: 11
    Last Post: 5th July 2011, 10:29 AM
  2. RM CC3 Log Files
    By soapyfish in forum Windows Server 2000/2003
    Replies: 11
    Last Post: 23rd June 2011, 02:07 PM
  3. Flushing NTFS log files
    By nicholab in forum O/S Deployment
    Replies: 2
    Last Post: 11th January 2010, 10:19 AM
  4. Constant corruption of system MSSQL 2005 files
    By googlemad in forum Windows
    Replies: 6
    Last Post: 1st October 2009, 05:57 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •