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?
July 30, 2001 at 12:39 pm
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.
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy