+ 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
    435
    Thank Post
    73
    Thanked 24 Times in 22 Posts
    Rep Power
    14

    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
    878
    Thank Post
    203
    Thanked 339 Times in 234 Posts
    Rep Power
    91
    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
    435
    Thank Post
    73
    Thanked 24 Times in 22 Posts
    Rep Power
    14
    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
  •