Restoration of Database using SQL Server 2005 : Part II


In the earlier post of this series, we had discussed how to restore a database from a Full database backup file. In this series, we are going to discuss how to restore a database with a Full and a Differential backup. To complete this demonstration, both the full and the differential backup files are present in the same media set.

B. Restoring a Database from a Full & a Differential Backup File

In this demo, we are going to restore the SKG_TEST2 database from the backup set ‘SKG_TEST2_FULL.bak’ on our development instance, SQL2K5Dev using SSMS.

1. Open SSMS, and connect to the instance SQL2K5Dev. Expand the Database folder, right-click on the database folder and select ‘Restore Database’.

image

2. On the Restore Database page, click on From device to select the backup media set from which we are going to restore the database. In the To database, enter the name of the database to be restored. For our demo, we are going to restore it on SKG_TEST2 database.

image

3. Once we select the backup media and enter the database name, we will get the following screen. In the backup set, we have two backup file, one contains a full backup and the other one contains a differential backup.

image

4. If the database is already exists on the instance, we can choose the Overwrite the existing files, in the Option tab of Restore Database page. Select the RESTORE WITH RECOVERY option, if you don’t have any log backup to restore after the data backup is completed. Click on Ok to start the restoration process.

image

5. Once the restoration process is complete, we will get the following screen:

image

Thus, the restoration of SKG_TEST2 database is completed successfully on our dev instance SQL2K5Dev. In the next part of this series, we will discuss how to restore a database from both data and log backup files.

Advertisements

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in Backup - Restore. Bookmark the permalink.

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