enter image description here

I have a full backup set (SQL server) and I am trying to restore the Database to a previous date and time. Every time I restore it (To another database) selecting a previous date that I want from the backup set, its RESTORES the latest version of the data. I can still query for data after the point in time. All I want to for the backup to stop at the point in time indicated (see image)

Is there something that i am missing?

DB: SQL server 2000

Tool used: Enterprise manager

  • 5
    I doubt anyone here remembers how Enterprise Manager works, so a screenshot is not really useful. Minimally you would need to provide the TSQL backup command used, any message output the RESTORE produced and any SQL Log entries written. – David Browne - Microsoft Oct 27 at 19:38
  • 1
    Related to David's comment: you might have better luck with using SSMS 2008, which still supported SQL Server 2000, but is a new enough tool that folks here will be able to help you get to a solution. – AMtwo Oct 27 at 20:21

You didn't say what backups you have. If you only have a full backup, then there's no point-i-time restore. It can only be restored to the "snapshot in time" it reflects (towards the end of the backup period).

If you do have also transaction log backups, then I agree that you should test SSMS and see what RESTORE commands it generates (you have a script button to see the TSQL) and then take it from there.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.