How to restore Microsoft SQL Server with Nordic Backup Pro
by admin | Jan 17, 2018 | guides |
| How to restore Microsoft SQL Server with Nordic Backup Pro |
|
|
| Print user guide |
|
| To begin a restore of files in Nordic Backup Pro, open NB Pro and click on "Restore". |
 |
|
| Choose the backup set to restore, if you have multiple backups setup in your account. Select the set to restore and click Next to choose the database. |
 |
|
| First, you can select the date which to restore at the top next to "Show files as of Job". By default, your latest backup will be selected. In the left pane, expand down to the name of the database you wish to restore, then check the .BAK file to restore in the right pane.
You will also need to specify the location to restore files to by clicking on 'Change'. Once a location has been selected with enough free space to accomodate the restore, click on 'Start Restore'. |
 |
|
| Once the database file has been restored, click on Close. |
 |
|
| Open the Microsoft SQL Server Managment Studio, expand the databases, then right click on 'System Databases'. Select 'Restore Database...' as shown. |
 |
|
| In the 'Restore Databases' dialog box, click the radio button next to 'From Device' in the source for restore section. Click on the button on the right side to select the file. |
 |
|
| In the 'Specify Backup' screen, click on 'Add' on the right side. |
 |
|
| Expand the drive where you restored the data. Your restored data will be located under the folder structure of %drive%/Microsoft SQL Server/%Servername%/%SQLVersion%/%Databasename%/*.bak file. Select the .BAK file, then click 'OK'. |
 |
|
| In the 'Specify Backup' dialog, you will now see the backup location listed of the .BAK you selected. Click 'Add' if you would like to restore multiple databases at one time, otherwise click 'OK'. |
 |
|
| Click on the drop down on the right side of the 'Restore Database' dialog next to 'To database' to select the original database name (or type a new one in the box).
Then check the box next to the database name under the 'Restore' column to confirm the database files to restore.
Click 'OK' to perform the restore operation. |
 |
|
| The database process will be completed once all data is written back to the SQL server. Click 'OK' when completed. |
 |
| US v1.0 |
| You have now completed the restore of Microsoft SQL Server data in Nordic Backup Pro. |
|
|
|
