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
