March 17, 2006 at 9:05 am
I have followed the following procedure while backing up my DB.
I took full backup on 1/1/2006 and scheduled a differenital backup on every day and appends this to the full backup.
and I am not taking any log backup.
SO If I want to restore My db upto 2/23/2006
To do so Can I restore the fullbackup (1/1/2006) and applying the differentail backup upto 2/23/2006.
But when I try the above I could not restore the DB. Any Ideas?
Thanks.
March 17, 2006 at 9:48 am
What is the backup and restore syntax you are using? What is the error? Did the restore fail when you tried to restore the full db, or when you tried to apply the differential?
March 17, 2006 at 10:59 am
You should have only restored two files.
1. The latest FULL backup prior to the 23rd.
2. The DIFFERENTIAL from the 23rd.
AND you should have restored the full backup using the command WITH NORECOVERY.
--restore full backup
RESTORE DATABASE dbname
FROM ......
WITH NORECOVERY
--restore differential
RESTORE DATABASE dbname
FROM ....
WITH RECOVERY
-SQLBIll
March 20, 2006 at 8:26 am
I am doing this restoration from enterprise manager.
In the general tab I am selection restore as
'database' and first backup to restore is the - full backup on 1/1/2006 and point in time restore is differentail backup on 2/23/2006.
March 21, 2006 at 7:12 am
You say you can't restore the database. What error are you getting?
(By the way 'point in time' is used with LOG restores only. With 'point in time' you can restore to a specific time.)
-SQLBill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply