chewychewy (1/15/2013)

---

Hi Guys,

Just curious will point in time recovery work in this case?

(1) Monday 2am - Transaction log backup via maintenance plan to disk

(2) Monday 7pm - full backup via maintenance plan to disk

(3) Monday 10pm - full backup to tape via 3rd party backup software, eg: backup exec, arc serve

(4) Tuesday 2am - Transaction log backup via maintenance plan to disk

Tuesday 3am - Users complain and want us to perform point in time recovery till tuesday 2am due to some data error.

If this is the case, can i use the full backup (2) with the transaction log taken at (4) to perform point in time recovery? I can't get (3) as the tape has some problem.

thanks