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 |
Drugukur
Starting Member
4 Posts |
Posted - 2012-04-03 : 10:57:00
|
Hello.
Problem is: There is now Full Backup1 and Diff from different DataBases. Diff is received from another Full Backup (Full Backup0). Full Backup1 was received from Full BackUp0 and was changed a little bit: some tables were added to this DB. Full Backup0 is lost.
Is it possible, using some tools or something else, restore DB with Full Backup1 and Diff to FullBackUp0?
Thank you. |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-04-03 : 11:17:40
|
What was the sequence that the backups were taken in?
-- Gail Shaw SQL Server MVP |
 |
|
Drugukur
Starting Member
4 Posts |
Posted - 2012-04-03 : 11:51:16
|
There was DataBase0 and Full Backup0 was received on it. DataBase1 was restored from Full Backup0. And after that Full Backup1 was received from DataBase1. |
 |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-04-03 : 12:02:02
|
And when was the differential taken? After FullBackup0? Was that diff restored to Database1?
-- Gail Shaw SQL Server MVP |
 |
|
Drugukur
Starting Member
4 Posts |
Posted - 2012-04-03 : 12:10:13
|
Diff was taken after Full Backup0. Diff wasn't restored to DB1 |
 |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-04-03 : 13:21:37
|
The best you can do is restore FullBackup1. The diff was based off a different backup and can't be restored with any other full backup
-- Gail Shaw SQL Server MVP |
 |
|
Drugukur
Starting Member
4 Posts |
Posted - 2012-04-03 : 13:42:26
|
Thank you for the answer. Could you name some tools which could be used for work with Diff files? |
 |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-04-03 : 14:47:56
|
Work with for what purpose?
-- Gail Shaw SQL Server MVP |
 |
|
|
|
|