December 4, 2001 at 9:24 pm
Hi
I had a backup plan like this
- monday to friday : diff
- saturday and sunday : full
- log every 6 hours everyday
Suppose on Wednesday one of my client accidentally change the wrong data. And he realized it on next day.
BOL said that i should do the following things:
- backup the current tlog
- restore last full w/ norecovery
- restore last diff w/ norecovery
- restore log with recovery to the point of time (using stop at)
which log should restore with recovery ? is it a current log or wednesday's log ?
what about transactions that proceed after the point of time ? do i have to rerun those transactions or not ?
December 4, 2001 at 10:31 pm
You'd restore the Sun full, Wed diff and wed log up to the time when the transaction occurred. Everything from that point until Thur would have to be re-run.
BTW, the Log Explorer tool is great for recreating these transactions.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply