July 30, 2001 at 12:13 pm
I have a (LDF) log file that has grown large (>1GB) in proportion to the database (43Mb). I have tried various techniques found in 'Q' articles and other forums to shrink this file but without success. Any ideas?
Steve Jones - SSC Editor
July 30, 2001 at 12:39 pm
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
July 30, 2001 at 8:33 pm
The script Steve referenced is terrific. A cheap hack is to detach the db, delete the log file, then use the sp_attach_single_file_db proc to reattach, it will generate a new log file.
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply