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’.
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.
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.
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.
5. Once the restoration process is complete, we will get the following screen:
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.