+ 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
    564
    Thank Post
    94
    Thanked 37 Times in 35 Posts
    Rep Power
    18

    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
    901
    Thank Post
    207
    Thanked 343 Times in 238 Posts
    Rep Power
    93
    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.

  3. #3
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    564
    Thank Post
    94
    Thanked 37 Times in 35 Posts
    Rep Power
    18
    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, 09:29 AM
  2. RM CC3 Log Files
    By soapyfish in forum Windows Server 2000/2003
    Replies: 11
    Last Post: 23rd June 2011, 01:07 PM
  3. Flushing NTFS log files
    By nicholab in forum O/S Deployment
    Replies: 2
    Last Post: 11th January 2010, 09:19 AM
  4. Constant corruption of system MSSQL 2005 files
    By googlemad in forum Windows
    Replies: 6
    Last Post: 1st October 2009, 04: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
  •