Post reply

Can I Recover to a previous point in time?

  • 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 2 posts - 1 through 3 (of 3 total)

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