singhluv
SSC Rookie
Points: 31
More actions
January 14, 2002 at 1:11 pm
#170408
My transaction log is VERY big , I have backed up, Shrinked, Truncate.
PLEASE help me
K. Brian Kelley
SSC Guru
Points: 114704
January 14, 2002 at 2:50 pm
#422170
If your active portion of the log is towards the end of the log, you aren't going to be able to shrink it very much. Here is a Q article which describes why this is occuring.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q256650
Here is the script posted by Steve Jones which creates the dummy transactions to help you shrink your log:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1
bkelley@sqlservercentral.com
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply