I have fullbackup at 5:00PM yesterday and Transactinal log every 30min (24 hours),I took Diff backup 7:00PM yester day and Diff backup 4:00 AM today.
My Transactional backup running every 30 min,
If any faulure what steps i have to take...
Please correct me if I am wrong
1.Restore Fullbackup(Yester day) with no recovery
2.Restore latest Differancial backup with no recovery
3.Restore all trasactional backups 4:30 with no recovery onwards.... and restore last trasactional backup with with rcovery
it is creect scenario ??..please help me..
Thanks in Advance
View Complete Post