Two log files consolidation

• srawant

  SSCommitted

  Points: 1829

  More actions

  July 22, 2009 at 10:31 am

  #136721

  Hi Guys,

  I have two T-log files for an existing database. How do I consolidate these 2 log files into one ?

  Thanks,

• JeremyE

  SSCoach

  Points: 16198

  More actions

  July 22, 2009 at 4:28 pm

  #1028706

  If the database is in Full recovery:

  After a tran log backup,

  ALTER DATABASE [DATABASENAME]

  REMOVE FILE [SECONDARYLOGFILENAME]

  If the database is in Simple recovery:

  Issue a CHECKPOINT

  ALTER DATABASE [DATABASENAME]

  REMOVE FILE [SECONDARYLOGFILENAME]