netbackup for sql server database
Need advise here.
I have the below backup strategy in placed
1. Daily Full DB Backup Via netbackup to Tape 8pm --> let's say this tape is corrupted.
2. 3 Hourly transaction Log backup via netbackup to Tape (12am,6am,12pm,6pm)
3. Daily Full DB backup to disk (via SQL maintenance Plan).
For netbackup, is there any option for (2) to work with the full backup taken by (3) to perform point in time recovery?
Technically I can restore the database (backup taken in 3) -- restore with no recovery option (as i wish to apply transaction logs to it for point in time recovery).
Is there any option for netbackup 2to restore only the transaction logs to facilite my point in time recovery?