Home > Backup database, Restore Database, SQL Queries, SQL Server, Storage Space, T-SQL > Restoring differential backup in SQL server

Restoring differential backup in SQL server

I have seen people struggling to restore differential back up. People tend to treat differential backup same as full backup. Restoring differential backup is simple with some minor differences in the way it is done for full backup.

the steps you need to follow are

1. Identify the diff backup that you need to restore.

2. Restore the latest full backup taken before the differential backup. follow the normal procedure as you always do. Select the backup file , Specify the database name , specify the location where the .mdf and .ldf files need to be placed.

3.  Check the option “RESTORE WITH NORECOVERY” for recovery state. click OK.

restore1

now refresh the databases folder in your server. You can see the restored database in the norecovery mode. It will not be accessible.

4. Restore the differential backup with the same options as selected for full backup( ofcourse different .bak file ), but change the recovery state option to  “RESTORE WITH RECOVERY” . click OK.

restore2

Now your database is completely restored and ready for use.

Please use the content at your own risk. In no event shall the
authors be liable for any claim, damages/issues that may be caused
by using the content.
Advertisements
  1. May 23, 2014 at 3:58 pm

    Hi my family member! I wish to say that this post is amazing, great written and come with approximately all vital infos.
    I’d like to see more posts like this .

  2. June 7, 2014 at 5:22 pm

    Thanks for some other magnificent post. Where ele could anyone
    geet that type of info in such a perfect method of writing?
    I’ve a presentation next week, and I am at the search for such info.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: