• Better backup the database to disk and then move the backup file to TAPE. SO that you can restore it on need. But plan this as each file will take disk space may be you can have last 3 days backup files on disk.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com