2012年3月2日 上午 07:04
I want to know if point in time recovery is possible with out differential backup.I have recet sunday night full backup and one of the user deleted table on wednesday afternoon.i have every 2 hrs transaction log.
And also can you please explain step-by-step procedure for point-in-time recovery.like to which state i have to change the database while doing point-in-time recovery.
Thanks IN Advance
2012年3月2日 上午 08:26
Differential backups are not required for point-in-time recovery, however they can reduce the restore time.
There are steps here : http://msdn.microsoft.com/en-us/library/ms190982.aspx
2012年3月2日 上午 10:54Thank You Vishal