SQL Restore

  • Hi Guys,

    Please could someone give me some guidance, I need to do a point in time restore however the difficulty is

    numerous log files have been inadvertently deleted.

    Currently have the daily full backup taken at 8pm Trans logs are taken every 15 mins & are missing until 2pm the next day.

    Question I have is what is the best way to recover where the log sequence is broken?

    I need to apply remaining logs until point of time of failure 6.03pm as stated I can replay these logs from 2pm - 6pm.

    Any help will be appreciated.

    Cheers

  • The left over transaction log backups are useless for a restore, they require the earlier log backups to function correctly.

    That means the only recovery point is 8pm at the time of full backup.

    You might be able to use ApexSQL log to see what transactions were occurring around the time of failure and at best, repair the existing database and undo the broken transactions, try the trial version: http://www.apexsql.com/sql_tools_log.aspx

  • If you've lost the log backups before 2pm (and it doesn't matter how many are lost, one is enough) and you don't have a differential or full backup taken after after 2pm, then you are not going to be able to restore to point of failure.

    Restoring to point in time requires a full backup, optionally a differential backup and then *all* log backups taken since the full/diff. If even one is missing, you cannot restore past the missing log backup.

    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 2 (of 2 total)

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