April 6, 2006 at 1:11 am
Hi all
I am trying to restore a database to a particular point in time, but it doesnot seem to be going as I have planned. When I specify the stopat time, the database is still restored to the point at which the database was backed up. Perhaps I am not seeing something here?
I have a database and database log backup stored within a bck file. The database backup has a date of 6/04/2006 11:28:15 AM and the log at 6/04/2006 12:03:30 AM, but I want to roll it back to 29/03/2006 10:00:00 AM. There are no prior database or log backups, so I figured that this transaction log backup would contain all the information needed to backup to a prior point. When I say 6/04/2006 I mean 6 Apr, 2006.
I run the the following command in query analyzer
RESTORE DATABASE [LandUnitRegister] FROM DISK = '<bak file path>' WITH NORECOVERY
RESTORE LOG [LandUnitRegister] FROM DISK = '<bak file path>'
WITH RECOVERY, STOPAT = '3/29/2006 10:00:00 AM'
GO
And query analyser states that everything is good, and that the restore has worked. When I check the tables I find that there are records beyod the recover point specified.
I thought maybe it is my datetime specification, so I try STOPAT = '29 Apr, 2006 10:00 AM' and I get no change.
Any help would be most appreciated, as I have wasted quite a lot of time browsing through resources with no joy.
Cheers
James
April 6, 2006 at 6:55 am
In order to restore to a point in time, your database backup must predate the point-in-time. Log backups can't take a database back in time.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply