May 29, 2002 at 1:34 pm
I must be missing something. I'm trying to shrink my log file after a large bcp. When I used the "Shrink database" off of EM->All Tasks for the database, it shrinks my datafile, which is fine, but it didn't do anything for the logfile. I then attempted to use DBCC Shrinkfile (hrprodlog, 900, truncateonly), which runs to success, I don't detect any shrinking. It remains 3.5 gig. Am I missing a step somewhere? Do I need to backup the log? In EM, the log has 500 meg used so i should be able to shrink it to 900 meg, correct? Thanks for any insight you can provide.
Terry
Terry
May 29, 2002 at 2:57 pm
One thing I failed to add, we're on SQL 7.0 sp2.
Terry
Terry
May 30, 2002 at 6:38 am
The problem is the Virtual Log files in the Transaction log are not releasing. This has been an issue with SQL 7. However checkout http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance and Management &CategoryID=1 for a script to help you get around this problem.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 30, 2002 at 8:11 am
Thanks for your help. I'm so glad I found this site!!
Terry
Terry
May 30, 2002 at 9:18 am
Very glad we could help. Tell your friends!
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply