I write a application use langgue C# and database SQL server 2000. My size of DataFile is about 130MB but Datalog 1.2GB and increase verry fast. How to do reduce size of datalog? Thank all!
What is your recovery model? You can set the maximum size for log file. or you can truncate log file ----------------------------------------
In addition of Dinesh's post.. if you have not setup backup plan for transaction log file..its expected to grow (unlimited if DB is not in simple recovery model) - Select the right recovery model for DB "as per requirements" - Setup a SQL job for taking full backup and empty out transaction log file. Hopefully I have not put too many new questions in your mind. But if I have, feel free to post more questions.. Deepak Kumar MVP, MCDBA - SQL Server Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.