Restore SQL Server Database backup

     Hi All,

     In a following post, we will see about How to restore SQL Server 2005 Database backup to SQL Server 2012.

1.     Copy your SQL Server 2005 database backup file to Physical location of another Server where SQL Server 2012 is exists.

2.     Open SQL Server 2012.

3.     Expand the database and select database => right-click on selected database => now click on Task => then click on Restore => then click on database.

4.     The Restore dialog box appears to restore the database backup. Select or type the name of a new or existing database for your restore operation. In Source for restore specify the source and location of backup sets to restore. Choose from Device radio button and then click the “…” button to specify backup file location.

5. In Specify Backup dialog box choose File as Backup Media and then click the Add button to choose the location of database backup file from which you want to restore the database as shown in the below snippet. Click OK to return to Restore Database dialog box.

6. In Restore Database Dialog box select the checkbox under Restore as shown in the below snippet and then select Option Page from the left pane.

7.     In Options Page of Restore Database dialog box select the checkbox next to Overwrite the existing database (WITH REPLACE) and choose the radio button next to Leave the database ready to use by rolling back uncommitted transactions. Additional transactional logs cannot be restored. (RESTORE WITH RECOVERY) as shown in the below snippet. Finally, click OK to start restoring the SQL Server Database.

8.Once the database is successfully restored you will get a popup message similar to the one shown in below snippet.

Thanks

Related Post