cancel
Showing results for 
Search instead for 
Did you mean: 

backup exec 2012 for SQL Server 2008

chewychewy
Level 3

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

 

 

1 REPLY 1

pkh
Moderator
Moderator
   VIP    Certified

You can do point in time recovery from both your tape and disk backups.