December 10, 2010 at 7:58 am
Hi Team,
could you please suggest me..
every sunday - full back up
Monday -- differential backup
Tuseday -- Diff & two consecutive Transactional log backups
Here my question is
How can Recovery...all the above..
Tx
December 10, 2010 at 8:13 am
I'm not clear what your question is. Please be more specific.
What is your backup stragety (frequency & types of backups)
Is that your restore plan ? If so, you don't need to restore the Monday DIFF, because it's included in the Tuesday DIFF
December 10, 2010 at 8:18 am
Hi ,
Yes my Database resoration sequence can you please guide me
how can i restore step by step
as per my knowledge
i am planning to restore
1st T-log backup
after than restore Monday Diff
finally i have to restore Sunday Fullbackups is it correct or not please correct me..
tx
December 10, 2010 at 8:36 am
You always restore in this order:
- full backup
- latest diff backup only
- log backups SINCE the last diff
December 10, 2010 at 8:37 am
1) Restore most recent FULL Backup
2) Restore most recent DIFF newer than the FULL
3) Restore T-Logs newer than the DIFF
use STOPAT if you need to restore to a specific time
Restores should be with NORECOVERY to enable the next restore to occur.
December 10, 2010 at 8:41 am
Hi Guys
Thank you very much for your spontinious reply..
Really appriciated.
Tx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply