SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Restore from different FullBackup and Diff		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Drugukur
Starting Member

Russia
4 Posts
Posted - 04/03/2012 :  10:57:00  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
4507 Posts
Posted - 04/03/2012 :  11:17:40  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
What was the sequence that the backups were taken in?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Drugukur
Starting Member

Russia
4 Posts
Posted - 04/03/2012 :  11:51:16  Show Profile  Reply with Quote
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.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts
Posted - 04/03/2012 :  12:02:02  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
And when was the differential taken? After FullBackup0? Was that diff restored to Database1?



--
Gail Shaw
SQL Server MVP
Go to Top of Page

Drugukur
Starting Member

Russia
4 Posts
Posted - 04/03/2012 :  12:10:13  Show Profile  Reply with Quote
Diff was taken after Full Backup0. Diff wasn't restored to DB1
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts
Posted - 04/03/2012 :  13:21:37  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Drugukur
Starting Member

Russia
4 Posts
Posted - 04/03/2012 :  13:42:26  Show Profile  Reply with Quote
Thank you for the answer. Could you name some tools which could be used for work with Diff files?
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts
Posted - 04/03/2012 :  14:47:56  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Work with for what purpose?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000