Post reply

Can I Recover to a previous point in time?

  • January 23, 2004 at 11:00 am

    #108844

    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

  • January 23, 2004 at 12:34 pm

    #491449

    You can restore to an earlier point in time. Let's say you want to restore to 1 January. Restore a full backup from that day or a previous day (use WITH NORECOVERY). Then restore any transaction log backups that may have data up to 1 January (use WITH NORECOVERY on all but the last one). Make sure you also use WITH STOPAT. Refer to the Books OnLine for more information. -SQLBill

  • January 23, 2004 at 1:17 pm

    #491455

    Thanks, that's just what I wanted to hear!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply