asked on

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.

jogos

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.

Anuradha Goli

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

Zhunya

ASKER

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.

ASKER CERTIFIED SOLUTION

jogos

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Zhunya

ASKER

Have to redesign backup policy, but databases sizes is 200Gb+

jogos

So differential backup of 200GB? While you stated looks like size as full backup?

Loock at backup compression (depending from witch sql-version)

Zhunya

ASKER

Yeah all of our backups are compressed (SQL Server 2008)