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 ShawSQL 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 ShawSQL 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 ShawSQL 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 ShawSQL Server MVP |
|
|
|
|
|
|
Restore from different FullBackup and Diff