February 13, 2003 at 8:36 am
I'm new with shrinking logs. The current size of the trans log file is the following:
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
7 2 173856 128 173856 128
I'm trying to reduce the current size to minimum size 128. I was directed to use this script http://support.microsoft.com/?id=256650 to help shrink the log but no luck.I ran the script few times.
Can anyone give me any suggestions?
Thanks in advance
February 13, 2003 at 9:08 am
Steve Jones has posted a script that he found that works wonderfully. Here it is:
http://www.sqlservercentral.com/scripts/contributions/26.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 13, 2003 at 9:17 am
quote:
Steve Jones has posted a script that he found that works wonderfully. Here it is:http://www.sqlservercentral.com/scripts/contributions/26.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
Thanks for the quick response. Just had more question.
Do i replace 'table_to_force_shrink_log' with our 'log_file_name' every where on the script?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply