Post reply

restore with full & transaction log

  • January 29, 2010 at 1:37 pm

    #209557

    Hi,

    Can I perform point in time restore, if I have the full backup file, as well as all the transaction log files since the full was created? Example, full created yesterday at 5pm, transaction logs at 9am, 10am, 11am, 12p, 1p, 2pm, my db goes bad at 235pm, how do i bring the db back to the most recent state with the backup files i have? Is differential backup necessary here?

    thanks!

  • January 29, 2010 at 1:58 pm

    #1110988

    You can restore your database using the most current full backup file and all transaction log backups taken since that full backup to recover your database.

  • January 29, 2010 at 2:03 pm

    #1110993

    I suggest you spend some time reading Books Online. There are good sections on restoring when a DB is in full recovery.

    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

  • January 31, 2010 at 2:35 am

    #1111299

    While you're reading up on it, pay close attention to the importance of trying to back up the 'tail of log' before commencing recovery operations.

    The start of a very useful section in Books Online is: http://msdn.microsoft.com/en-us/library/ms187048.aspx

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

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

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