SQL Server Performance

Why size of Datalog is verry large

Discussion in 'General DBA Questions' started by thangnc, Aug 12, 2006.

  1. thangnc New Member

    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!
  2. dineshasanka Moderator

    What is your recovery model?
    You can set the maximum size for log file.
    or you can truncate log file


  3. deepakontheweb New Member

    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.

Share This Page