June 11, 2002 at 10:09 am
Hi all,
I have a question: I´m working w/SQL server 7, OS: WINNT. What can I do to reduce the size of the LDF file (the MDF is quite small) because the HD is coming full. I´ve tried: first changing the percentage of growing of the file. Then I set the ammount of MB to "grow" the size of the file in 1MB. There are two DB in the same HD, and they both are growing & growing everyday. Once we had to reinstall the server in order to reassign the size of the HD (it´s an array) and I don´t pretend to do it again!!
I really appreciate any suggestion.luis.balderas@siemens.com.mx
June 11, 2002 at 3:27 pm
The following link is to a script that will accomplish shrink the log file. http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance and Management &CategoryID=1
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply