Post reply

Database corrupt

  • February 5, 2009 at 11:56 pm

    #155239

    suppose every night i am taking full backup ,every 2 hours taking differnetial backup.every 1 hour taking transcation log backup.

    I have transcation log backup up to 01:00PM..but my database is crashed on 01:15PM.How to retrive the 15 Mins Data.

  • February 6, 2009 at 12:01 am

    #939314

    Depends how the DB crashed.

    If the log is still accessible and SQL's still running, then you back up the tail of the log (no truncate, no recovery options), and restore that as the last log backup when you restore the database.

    If the log is not accessible (say the log drive failed), then you cannot retrieve that last 15 min of data.

    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

  • February 6, 2009 at 12:04 am

    #939315

    The Order goes like this:

    Bakcup the Acitve portiong of the log(Tail log)

    Recent Full backup(No Recovery)

    Recent Differential backup(No Recovery)

    Latest Tlog backup(No Recovery)

    and finally Tail Backup with STOPAT (Recovery)

  • February 6, 2009 at 12:05 am

    #939316

    Thank you

  • February 6, 2009 at 12:10 am

    #939318

    Krishna (2/6/2009)

    and finally Tail Backup with STOPAT (Recovery)

    You only need STOPAT if there are some commands in the log that you don't want to restore (for eg a user dropping a table). If there are no such commands, leave out STOPAT and restore the entire log tail.

    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

  • February 6, 2009 at 12:40 am

    #939328

    Bakcup the Acitve portiong of the log(Tail log)-how to take the tail log backup(Command)..........?

  • February 6, 2009 at 12:45 am

    #939330

    n.yarramreddy (2/6/2009)

    Bakcup the Acitve portiong of the log(Tail log)-how to take the tail log backup(Command)..........?

    BACKUP LOG WITH NO_TRUNCATE

    Look in BOL to understand the concept before working on it.

  • February 6, 2009 at 12:49 am

    #939332

    Thank u krishna

  • February 6, 2009 at 2:18 pm

    #939790

    My Pleasure!

    Please do post if you have any errors, we would be able to help you out

Viewing 9 posts - 1 through 8 (of 8 total)

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