SQL Server Performance

How to reduce the size of Transaction Log File

Discussion in 'Getting Started' started by irfibaig, May 31, 2007.

  1. irfibaig New Member

    Hi Bros/Gals,

    Can anybody help, how to reduce the size of Transaction Log File in SQL Server 2000.

    Thanks,

    Irfan Baig.
  2. satya Moderator

    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.
  3. madhuottapalam New Member

    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

Share This Page