User Tools

Site Tools


public:module:microsoft_sql_database:restore

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
public:module:microsoft_sql_database:restore [2019/09/12 15:52]
ronnie.chan
public:module:microsoft_sql_database:restore [2019/09/19 18:03] (current)
ronnie.chan
Line 1: Line 1:
 ====== Restoring Backup for Microsoft SQL Server ====== ====== Restoring Backup for Microsoft SQL Server ======
 +----
 Blow are the steps for restoring backup for Microsoft SQL Server: Blow are the steps for restoring backup for Microsoft SQL Server:
  
Line 6: Line 7:
 2. Select the backup set that you would like to restore. ​ \\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_032.png?​640}} 2. Select the backup set that you would like to restore. ​ \\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_032.png?​640}}
    
-3. Select the backup destination that you would like to restore data from. +3. Select the backup destination that you would like to restore data from.   \\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_033.png?​640}}
    
-4. Select the database(s) or raw file(s) you would like to restore. You can also choose to restore backed up database or raw file from a specific backup job of your choice using the Select what to restore drop-down menu at the top. Click Next to proceed when you are done with the selection. +4. Select the database(s) or raw file(s) you would like to restore. You can also choose to restore backed up database or raw file from a specific backup job of your choice using the Select what to restore drop-down menu at the top. Click Next to proceed when you are done with the selection. 
-  Restoring database - expand the menu tree to select which database to restore. Follow 5a below to select restoring to the original SQL server or an alternate SQL server.  + 
-  +  * **Restoring database** - expand the menu tree to select which database to restore. Follow 5a below to select restoring to the original SQL server or an alternate SQL server. ​  \\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_034.png?​640}} 
-  Restoring raw file - you can select individual raw database file to restore by clicking the Restore raw file checkbox at the left bottom corner. Follow 5b below to select the path where you would like to restore the raw file(s) to.  + 
-  +  * **Restoring raw file** - you can select individual raw database file to restore by clicking the Restore raw file checkbox at the left bottom corner. Follow 5b below to select the path where you would like to restore the raw file(s) to. \\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_035.png?​640}} 
-Limitations:​ + 
-If you would like to restore database with the Alternate location option, you can only choose to restore one database at a time. +<WRAP indent> <WRAP info> ​ 
-If you would like to restore database to an alternate SQL server with the Restore raw file option, make sure you have checked the Restore raw file option.  +**Limitations:​** \\  
-5. Select the destination to restore. Refer to 5a or 5b below for steps to restore the database automatically (Restore database to Original/​Alternate location) or manually (Restore raw file). +  ​* ​If you would like to restore database with the Alternate location option, you can only choose to restore one database at a time. \\ 
-5a. Select to restore the database to its Original SQL server, or to an Alternate SQL  server. +  ​* ​If you would like to restore database to an alternate SQL server with the Restore raw file option, make sure you have checked the Restore raw file option. 
-  Restore to Original SQL server +</​WRAP>​ </​WRAP>​  
-Select the Original location option, then press Next to proceed. + 
-  +5. Select the destination to restore. Refer to 5a or 5b below for steps to restore the database automatically (Restore database to Original/​Alternate location) or manually (Restore raw file). 
-If you would like to modify the Verify checksum of in-file delta files during restore setting, click Show advanced option. + 
-  Restore to Alternate SQL server (only for restoring raw file) +<WRAP indent>​ 
-i. Select the Alternate location option, then press Next.+**5a.**  
 + 
 +Select to restore the database to its Original SQL server, or to an Alternate SQL server. 
 + 
 +  * **Restore to Original SQL server** \\ Select the Original location option, then press Next to proceed. ​\\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_036.png?​640}} \\ If you would like to modify the Verify checksum of in-file delta files during restore setting, click Show advanced option. 
 + 
 +  * **Restore to Alternate SQL server (only for restoring raw file)** 
 +<WRAP indent><​WRAP indent> 
 +i. Select the Alternate location option, then press Next. \\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_037.png?​640}} ​
    
 If you would like to modify the In-File Delta type (for Full backup set type only), Destinations and Retention Policy settings, click Show advanced option. If you would like to modify the In-File Delta type (for Full backup set type only), Destinations and Retention Policy settings, click Show advanced option.
-ii. Click Browse to select the locations where you would like to restore the database and log files to. Name the new database, then.+ 
 +ii. Click Browse to select the locations where you would like to restore the database and log files to. Name the new database, then. \\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_038.png?​640}} ​
    
-iii. Click Next to proceed when you are done with the settings.  +iii. Click Next to proceed when you are done with the settings. 
-5b. i) If you have chosen to restore raw file, choose the location path where you would like the raw file(s) to be restored to. Click Next to proceed.+</​WRAP></​WRAP>​ 
 + 
 +**5b.**  
 + 
 +iIf you have chosen to restore raw file, choose the location path where you would like the raw file(s) to be restored to. Click Next to proceed. ​\\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_039.png?​640}} ​
      
 If you would like to modify the In-File Delta type (for Full backup set type only), Destinations and Retention Policy settings, click Show advanced option. If you would like to modify the In-File Delta type (for Full backup set type only), Destinations and Retention Policy settings, click Show advanced option.
-ii) Restore the database manually with the restored database file via the SQL Server Management Studio. Refer to the MS KB article below for instructions. + 
-https://​technet.microsoft.com/​en-us/​library/​ms177429%28v=sql.110%29.aspx  +iiRestore the database manually with the restored database file via the SQL Server Management Studio. Refer to the MS KB article below for instructions. 
-6. Select the temporary directory for storing temporary files, such as delta files when they are being merged, click Restore to start the restoration.+[[https://​technet.microsoft.com/​en-us/​library/​ms177429%28v=sql.110%29.aspx]] 
 + 
 +</​WRAP>​ 
 + 
 +6. Select the temporary directory for storing temporary files, such as delta files when they are being merged, click Restore to start the restoration. ​\\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_040.png?​640}} ​
    
-7. The following screen with the text Restore Completed Successfully shows when the restoration is completed.+7. The following screen with the text Restore Completed Successfully shows when the restoration is completed. ​\\ {{public:​module:​microsoft_sql_database:​cloudbacko_module_sql_041.png?​640}} ​
    
  
public/module/microsoft_sql_database/restore.1568274752.txt.gz · Last modified: 2019/09/12 15:52 by ronnie.chan