Delete last 3 months Transaction Log

• isa-369599

  SSCommitted

  Points: 1602

  More actions

  March 9, 2008 at 11:46 pm

  #187360

  Hello everyone, i want to truncate my database log file, but not want to drop all log,

  as i want to drop let say previous last 3 months log . Plz tell me how can i do this by using

  Queries in SQL Server 2005.

  Plz reply me asap. Thanx in Advance.

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  March 10, 2008 at 5:33 am

  #787283

  Can't be done... it's all or nothing.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• twalston

  Mr or Mrs. 500

  Points: 505

  More actions

  March 10, 2008 at 5:45 am

  #787288

  I cannot find anything regarding selective truncation of the transaction log. Apparently its an all or nothing prospect that should happen automatically.

  http://technet.microsoft.com/en-us/library/ms189085.aspx explains the truncation process.

  Additionally there is a link http://technet.microsoft.com/en-us/library/ms345414.aspx about things that can cause a delay in this happening.

  Is your reason for wanting to keep 3 months of transaction logs for log mining purposes?