SQL Server Performance Forum – Threads Archive
How to reduce the size of Transaction Log FileHi 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
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
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 …
How to stop the transaction log of a SQL Server database from growing …