Post reply

Tail of Log backup

  • 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?

  • 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

  • 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/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply