Tail of Log backup

• kesava.reddy12

  Newbie

  Points: 5

  More actions

  November 28, 2009 at 4:17 am

  #206782

  Hi,

  How to take tail of log backup?

  What is Tail of log backup?

  can any one explain me with example?

• ps.

  One Orange Chip

  Points: 29423

  More actions

  November 28, 2009 at 5:41 am

  #1085093

  From BOL :

  A log backup taken from a possibly damaged database to capture log records that have not yet been backed up. A tail-log backup is taken after a failure, in order to prevent work loss and can contain either pure log or bulk log records.

  Code from BOL to take a tail log backup

  BACKUP LOG MyAdvWorks_FullRM

  TO MyAdvWorks_FullRM_log1

  WITH NO_TRUNCATE

  GO

  ---

  
  Pradeep Singh

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  November 28, 2009 at 6:05 am

  #1085094

  kesava.reddy12 (11/28/2009)

  ---

  Hi,

  How to take tail of log backup?

  What is Tail of log backup?

  can any one explain me with example?

  Hi Kesave,

  Please read the following link

  Tail of Log Backup

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/