• chewychewy (1/15/2013)


    thanks Lynn.

    Have u used backup exec or arc serve before?

    1. Daily full backup via backup exec to tape at 9pm.

    This tape will be send offsite for safe keeping.

    2. Daily full db backup to filesystem via SQL Maintenance Plan at 9pm

    3. 5 hourly interval db transaction logs backup via backup exec to tape.

    This tape will be onsite

    I heard with this, I can't do point in time recovery using option 2 and 3.

    Seems like backup exec doesn't have an option to restore the transaction logs to file system, for us to

    using it with option 2.

    Any idea?

    thanks

    You will have to use the native RESTORE WITH NORECOVERY to restore the full backup and backup exec's RESTORE LOG (with norecovery if more than one log file) to restore the log files directly to the database. Backups directly to tape are not like a backup to disk and then a backup of that file to tape.