Post reply

Taking "Active" transaction log backup. Is it possible if the database is not accessible?

  • April 30, 2010 at 2:01 pm

    #140059

    Hello Experts

    Can you please suggest how should be done in the below scenario:

    As we know that at any point of time data will be available in the active T-Log, if the recovery mode is "Full". However, at a certain point of time the database crashed and I am unable to "use <database>", in that case how to recover the data from the active transaction log buffer?

    Please suggest ...

    Thanks.

  • April 30, 2010 at 2:03 pm

    #1160733

    What is the status of the database?

    In Recovery, Offline, Online?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 30, 2010 at 2:08 pm

    #1160739

    It is still online. Howvere unable to "use the database".

    Thanks.

  • April 30, 2010 at 2:11 pm

    #1160743

    Try this article.

    Look at the tail log section.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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