Restore Database from differential backup

Hi, is there way to restore old (more 1 month old) over existing database?

Differential backup file size looks like full backup file.
ZhunyaAsked:
Who is Participating?

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

x
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.

jogosCommented:
To see what your backup realy is use RESTORE HEADERONLY to check the info in the backup file
http://msdn.microsoft.com/en-us/library/ms178536.aspx


How to restore the management studio way
http://msdn.microsoft.com/en-us/library/ms175510.aspx
and even if you don't restore that's also a way to view the backup-history of that db.
0
Anuradha GoliSystems Development / Support SpecialistCommented:
In SQL Server management studio

Select Restore Database from databases menu -->
In Destination to Restore , select the database
and From device ,click browse to--> Click Add from popup -->browse to location of backup
0
ZhunyaAuthor Commented:
Hi, jogos.

My file is definitely Differential Backup (Backup Type - 5).

Backup History consists of last 30 days. But in my situation users asking me to restore backup wich is 40 days old. At this point i have only differential backups with no preceding full backups.
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

jogosCommented:
<< At this point i have only differential backups with no preceding full backups.>>
Oeps. A differential backup only is restorable starting from the previous full backup. Hope you still have one on tape!

The rule: you don't just hold your backups for 40 days.. the more specific you keep shorter as the more basic

For example
Full backups you hold longer (ex 15 months) , 2 months on disk but your backupdisk is tape-backuped (frequency one every week)
Differential backups you keep shorter , ex 30 days (frequency  one every day)
Transaction log backups again shorter , ex 7 days (frequency one every ...)

The advantage of a differential backup is that it is faster and takes less space because it only stores the changes. An if your differential backup is almost the size of a full backup then it means you have so much changes.  .... rethink the if the differential  backup is still an advantage and that you don't need to increase the frequency of your full backups.
0

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
ZhunyaAuthor Commented:
Have to redesign backup policy, but databases sizes is 200Gb+
0
jogosCommented:
So differential backup of 200GB? While you stated looks like size as full backup?


Loock at backup compression (depending from witch sql-version)
0
ZhunyaAuthor Commented:
Yeah all of our backups are compressed (SQL Server 2008)
0
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

From novice to tech pro — start learning today.