We are currently backing up a SQL 2000 database and log daily with an EM maintenance job. This job writes the backup files to the server containing SQL Server and deletes backup files older than 2 weeks. We also use Veritas software to copy the SQL backup output files to tape . We keep these tapes for a month. Is it possible to recover the database to a point in time older than 2 weeks by restoring one of the backups from the Veritas tape to the server or does SQL Server reject the backup because it is older than 2 weeks?
Thanks,
John