SQL Server Performance Forum – Threads Archive

How to reduce the size of Transaction Log File

Hi Bros/Gals, Can anybody help, how to reduce the size of Transaction Log File in SQL Server 2000. Thanks, Irfan Baig.

DBCC SHRINKFILE, have a read on SQL Server books online and make sure you have upto date one:http://www.microsoft.com/downloads/details.aspx?FamilyID=A6F79CB1-A420-445F-8A4B-BD77A7DA194B if not download.
But before that I would like to know whether you have any schedule of transaction log backup in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

few useful links
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1628236&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1618105&SiteID=1
Transaction Log Physical Architecture http://msdn2.microsoft.com/en-us/library/ms179355.aspx
Troubleshooting a Full Transaction Log (Error 9002)
msdn2.microsoft.com/en-us/library/ms175495.aspx Managing the Transaction Log
msdn2.microsoft.com/en-us/library/ms345382.aspx How to use the DBCC SHRINKFILE statement to shrink the transaction log …
support.microsoft.com/kb/907511
How to stop the transaction log of a SQL Server database from growing …
support.microsoft.com/kb/873235
Madhu

]]>