Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2009-03-04 : 03:53:49
|
| Hi, I'm creating full DB backup at first day of each month. then I'm creating differential backup everyday. Now suppose its 14th day of month an I want to restore backup of 7th day to a new DB. I restore the full backup to a new DB with NORECOVERY option first. Then when I want to restore the backup of 7th day I'm getting following error: This differential backup cannot be restored because the database has not been restored to the correct earlier state. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-03-04 : 05:38:47
|
quote:
Originally posted by Peace2007
Hi, I'm creating full DB backup at first day of each month. then I'm creating differential backup everyday. Now suppose its 14th day of month an I want to restore backup of 7th day to a new DB. I restore the full backup to a new DB with NORECOVERY option first. Then when I want to restore the backup of 7th day I'm getting following error: This differential backup cannot be restored because the database has not been restored to the correct earlier state.
some one must have taken the ad hoc full backup...and the differential backup is tied to that full backup...Regards,Ahmad Osama |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-04 : 11:39:01
|
| Look at MSDB.backupsets for information. |
|
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-03-04 : 13:47:08
|
| That's the problem to resolve that the new "COPY ONLY" option is added in BACKUP command. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2009-03-05 : 00:25:03
|
| Thanks all for your comments |
|
|
|
|
|
|
Differential Backup