Restore a database with multiple differential sets

Hi Experts, I had to restore a database from a while ago that had a full backup and several differentials (which is taken every day).

I thought when restoring a full and several DIFFs, all you had to do was to restore the FULL and the latest DIFF, but for some reason the server keps checking all the DIFFs (the ones between the FULL and the latest DIFF)

Does anyone know why that is? I am sure there must be a reason for the engine to pick all the DIFFs, NO?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You have to restore your FULL database WITH NO RECOVERY option first and then you need to restore ONLY THE LAST differential backup WITH RECOVERY option if you don't have to restore transaction logs as well.

If your backups were performed without issues that is what you should do and you should have no problems. Each differential backup contains all the changes from the LAST full backup performed so it will have the changes form any previous differential backups included. That is why you need only the last one..

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott PletcherSenior DBACommented:
You are right, you only need the last one.

>> I am sure there must be a reason for the engine to pick all the DIFFs, NO? <<

I think it's just that its "logic" is not that sophisticated; it doesn't really "understand" what's going on, of course.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.