Post reply

Tail log backup

  • December 11, 2009 at 4:48 am

    #218638

    I want to test a recovery strategy of our live database in a test environment. My question is if I take a tail log backup of the live database will that break the chain of transaction log backups currently in place, or will they carry on as normal?

    Thanks

  • December 11, 2009 at 5:24 am

    #1091090

    Hi ,

    Look the MS Article about tail of log backup

    Also read the gail's article

    Managing Transaction Logs[/url]

    Edited:Post the correct URL

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

  • December 11, 2009 at 6:27 am

    #1091114

    Hello Experts

    I need a quick response from you guys.

    Suppose check the below scenario to understand my requirement:

    In my project the Full database backup is being performed everyday night at 10 P.M. There is no Differential backup and transaction log backup is taken in every 15 mins interval. Now my database crashed at 10:10 PM. How to retrieve the 10 mins data?

    [ans:] I know the answer for this. It is we need to get the 'tail backup' so that as much as data we can retrieve from the active transaction log buffer. But how to do it? Since my database is crashed and I'm unable use the database to fire the below query which is used for 'tail backup'.

    ======== Example Syntax =================

    USE master;

    --Create tail-log backup.

    BACKUP LOG AdventureWorks

    TO DISK = 'Z:\SQLServerBackups\AdventureWorksFullRM.bak'

    WITH NORECOVERY;

    Please suggest!!

    Thanks.

  • December 11, 2009 at 9:01 am

    #1091234

    Sourav-657741 (12/11/2009)

    Hello Experts

    I need a quick response from you guys.

    Please start a new thread for a new question rather than hijacking someone else's thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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