Tail backup

  • In what circumtances can we recover the database to point of time failure?

    I mean can we take the tail backup in every case(eg:-database is offline)

  • Tail-log backup

    A tail-log backup is a transaction log backup that includes the portion of the log that has not previously been backed up (known as the active portion of the log). A tail-log backup does not truncate the log and is generally used when the data files for a database have become inaccessible but the log file is undamaged.

    MJ

  • Tail-log backup

    A tail-log backup is a transaction log backup that includes the portion of the log that has not previously been backed up (known as the active portion of the log). A tail-log backup does not truncate the log and is generally used when the data files for a database have become inaccessible but the log file is undamaged.

    MJ

  • Can we take tail tlog backup even when db is offline/damaged/correpted

  • chk2009 (11/10/2009)


    Can we take tail tlog backup even when db is offline/damaged/correpted

    Yes. Tail Log Backups

  • Paul White (11/10/2009)


    chk2009 (11/10/2009)


    Can we take tail tlog backup even when db is offline/damaged/correpted

    Yes. Tail Log Backups

    Thanks for your reply:-)

    How can we do that, can you pls explain me in detail, which command to use

  • chk2009 (11/10/2009)


    Thanks for your reply:-)

    How can we do that, can you pls explain me in detail, which command to use.

    It's all documented in the link I provided before. Just click on the words 'Tail Log Backups'... 😉

  • Paul White (11/10/2009)


    chk2009 (11/10/2009)


    Thanks for your reply:-)

    How can we do that, can you pls explain me in detail, which command to use.

    It's all documented in the link I provided before. Just click on the words 'Tail Log Backups'... 😉

    It seems likely to me that the OP is in a serious bind here. If he cannot read that article and do what is necessary I highly recommend he/she get some help onboard to assist in the recovery. Actually they probably ought to do that regardless. 😎

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • chk2009 (11/10/2009)


    Can we take tail tlog backup even when db is offline/damaged/correpted

    Providing the log is available, yes. If the log is damaged/missing then no. If it's just the mdf/ndf files that are damaged/missing/corrupt then yes.

    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 9 posts - 1 through 8 (of 8 total)

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