Database Crash

  • Suppose I am taking daily nigt taking full backup,,every 2 hours taking differnetial backup.every 1 hour taking transcation log backup.

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

  • You can use stopat clause..

    you can see syntax and details in help

    type restore database and press cntrl+shift+f2

    you can see details over there.

  • Depends on the type of crash. If the tran log is still available and SQL is still running, then you can take a tail-log backup (see books online for details, the option is NO_Truncate under BACKUP LOG)

    If the log file is not available, then you cannot retrieve that 15 min of data. That's why the interval between tran log backups should be the maximum data that you are willing to lose in a disaster.

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

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