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