hi all,
when restoring a sql server 2008 database to a date from which the data is only available on tape i do not have the ability to select the times at which synchronizations occurred (every 15 minutes). rather, i can
only select the points in time at which the express full backups occurred (8pm daily).
1. is this normal behaviour?
2. if so, does this mean that i will need to extend my short-term retention range to as many days as i wish to have the ability to restore the log files so as to restore to any point in time?
if needed here are some details of the protection group in question:
short term is using disk
short term goals: retention 7 days, synch. freq. 15 minutes, express full 8pm daily
long term is using tape
long term goals: retention range 1, backup schedule 9pm daily & 9pm last sunday of every month
thank you