KB ID : 105
Published : March 16, 2016
Created : March 16, 2016
Last Modified : June 26, 2016

Challenge

Restoring MSSQL Server Database from one machine to another machine.

Solution

To restore SQL Server database in MACHINE B, please follow the steps given below:

  1. SQL-Server data could be restored from backup server A to MACHINE B in one of the following ways:-

    • Restore SQL Server database backup schedule data locally in backup server A through the menu ‚ÄúRecovery" search for the appropriate "Backup Name -> Proceed to Restore Backup" , and then manually transfer the data to MACHINE B.

    OR

    • From MACHINE A, do a regular restore by choosing the option "Restore data from backup server only (I will separately run Vembu NetworkBackup through the 'locally restored files' to restore the SQL Server later)" , and then manually transfer the data to MACHINE B.
  2. Once the data has been transferred to MACHINE B, you need to edit the restore.conf located in "<restored_location>/plugin/" folder.

    • Open the restore.conf located in "<restored_location>/plugin/" folder.
    • Change the SqlInstanceName attribute value to MACHINE B SQL Server Instance name. And before restoring the SQL-Server, go to the "SQL Server connection properties" page and then login to MACHINE B SQL Server Instance at least once.
    • Change the ClientIdentity attribute value to MACHINE B StoreGrid Identity.
    • Save and close the file.
  3. Database to be restored should not exists in the Mapped Drive of the MACHINE B. Please check that database files to be restored exists in the Local Drive of the MACHINE B, if not please transfer the restored data to the Local Drive of the MACHINE B .

  4. In the top menu of the Vembu NetworkBackup WebConsole, select: "Restore". It will display the "List Of Backup For Restore" page. In the Action Column of the any SQL backup schedule, click on the Restore icon.

  5. Choose the second option in "Step 0: Decide how to restore" settings to restore SQL Server database from the previously restored data, and then enter the local restore location and click "Submit Location" button to restore SQL Server data from the local folder.

  6. Proceed with the remaining steps in Restore SQL Server Database page to restore the SQL Server database.

edit retag flag offensive close merge delete