How to restore Microsoft SQL Server with Nordic Backup Pro | Secure Cloud Backup Software | Nordic Backup
<table class="body_main_table"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr class="body_main_table"><!-- [et_pb_line_break_holder] --><td class="body_main_table"><!-- [et_pb_line_break_holder] --><table class="body_headline"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr class="body_headline"><!-- [et_pb_line_break_holder] --><td class="body_headline">How to restore Microsoft SQL Server with Nordic Backup Pro</td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --></td><!-- [et_pb_line_break_holder] --><td align="center" valign="middle" width="190"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2" align="left" valign="top" width="100%"><!-- [et_pb_line_break_holder] --><table class="body_main_table"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td class="body_content" colspan="3"><!-- [et_pb_line_break_holder] --><table class="blue" border="0" width="100%" cellspacing="5" cellpadding="5"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td class="blue" colspan="2" align="right" valign="top"><a style="text-decoration: none;" href="/how-to-restore-microsoft-sql-server-with-nordic-backup-pro.html&print=1" target="_new">Print user guide <i class="fa fa-print"></i></a></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">To begin a restore of files in Nordic Backup Pro, open NB Pro and click on "Restore".</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//filerestore55/file_rest_en_pro_0101.png" alt="Open Nordic Backup Pro and click Restore" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">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.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_01.png" alt="Select the backup set to restore" title="Select the backup set to restore" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --><p class="guide-break"></p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><table class="blue" border="0" width="100%" cellspacing="5" cellpadding="5"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td height="0"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">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.<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->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'.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_02.png" alt="Check the database file to restore" title="Check the database file to restore" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">Once the database file has been restored, click on Close.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_03.png" alt="Click on Close once restore is complete" title="Click on Close once restore is complete" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --><p class="guide-break"></p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><table class="blue" border="0" width="100%" cellspacing="5" cellpadding="5"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td height="0"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">Open the Microsoft SQL Server Managment Studio, expand the databases, then right click on 'System Databases'. Select 'Restore Database...' as shown.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_04.png" alt="Select Restore Database" title="Select Restore Database" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">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.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_05.png" alt="Click From Device to select the restore database" title="Click From Device to select the restore database" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --><p class="guide-break"></p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><table class="blue" border="0" width="100%" cellspacing="5" cellpadding="5"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td height="0"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">In the 'Specify Backup' screen, click on 'Add' on the right side.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_06.png" alt="Add the file location to restore" title="Add the file location to restore" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">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'.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_07.png" alt="Select the .BAK file for restore" title="Select the .BAK file for restore" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --><p class="guide-break"></p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><table class="blue" border="0" width="100%" cellspacing="5" cellpadding="5"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td height="0"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">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'.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_08.png" alt="Confirm that the backup location is added" title="Confirm that the backup location is added" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">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).<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->Then check the box next to the database name under the 'Restore' column to confirm the database files to restore.<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->Click 'OK' to perform the restore operation.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_09.png" alt="Select the database name or type a new one" title="Select the database name or type a new one" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --><p class="guide-break"></p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><table class="blue" border="0" width="100%" cellspacing="5" cellpadding="5"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td height="0"></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">The database process will be completed once all data is written back to the SQL server. Click 'OK' when completed.</td><!-- [et_pb_line_break_holder] --><td align="left" valign="top" width="300"><img src="/wp-content/userguides//dbbackup55/sql_rest_en_10.png" alt="Click OK when restore is completed" title="Click OK when restore is completed" border="0" /></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="left" valign="top">US v1.0</td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td colspan="2"><!-- [et_pb_line_break_holder] --><table class="blue" border="1" width="100%" cellspacing="0" cellpadding="5"><!-- [et_pb_line_break_holder] --><tbody><!-- [et_pb_line_break_holder] --><tr><!-- [et_pb_line_break_holder] --><td align="center" valign="middle">You have now completed the restore of Microsoft SQL Server data in Nordic Backup Pro.</td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table><!-- [et_pb_line_break_holder] --></td><!-- [et_pb_line_break_holder] --></tr><!-- [et_pb_line_break_holder] --></tbody><!-- [et_pb_line_break_holder] --></table>
Share This

nb@nordic-backup.ru