04-17-2013 08:16 AM
Hi Guys,
Let's say I have the below backup in placed for SQL Database via backup exec:
1. daily full db backup to tape - 11pm
2. daily fill db backup to disk - 9pm
3. hourly transaction log backup do disk
When comes to restoration, am i able to use the full db backup taken to tape with the hourly transaction log backup taken to disk (1+3) in order to perform a point in time recovery? Or point in time recovery can only works using 2+3?
Kindly advise.
thanks
04-17-2013 11:43 PM
You can do point in time recovery from both your tape and disk backups.