Point - in - time Recovery

Question

  

Hello All

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

Answer 1

Hi,

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

---

- Vishal

SqlAndMe.com

Answer 2

Thank You Vishal