Restoring MSSQL Server Database from one machine to another machine.

To restore a SQL Server database on MACHINE B from a backup taken on backup server A, follow these steps:

1. Local Restore in Backup Server A:

1. Schedule a SQL Server database backup locally in backup server A through the "Recovery" menu.
2. Search for the appropriate "Backup Name -> Proceed to Restore Backup" and manually transfer the data to MACHINE B.

   OR

1.  From MACHINE A, perform a regular restore by choosing the option "Restore data from backup server only." Manually transfer the data to MACHINE B.

2. Transfer Data to MACHINE B:

1. After transferring the data to MACHINE B, edit the restore.conf file located in "<restored_location>/plugin/" folder.
2. Open restore.conf and:

1. Change the SqlInstanceName attribute value to MACHINE B SQL Server Instance name.
2. Log in to MACHINE B SQL Server Instance at least once from the "SQL Server connection properties" page.
3. Change the ClientIdentity attribute value to MACHINE B StoreGrid Identity.
   

1. Save and close the file.
   

3. Check Database Files:

1. Ensure that the database to be restored does not exist in the Mapped Drive of MACHINE B.
2. Confirm that database files to be restored exist in the Local Drive of MACHINE B. If not, transfer the restored data to the Local Drive of MACHINE B.

4. Initiate Restore in Vembu NetworkBackup WebConsole:

1. In the Vembu NetworkBackup WebConsole, select "Restore" from the top menu.
2. On the "List Of Backup For Restore" page, click the Restore icon in the Action Column of the desired SQL backup schedule.
3. Choose the option to restore SQL Server database from previously restored data.
4. Enter the local restore location and click "Submit Location."

5. Complete SQL Server Database Restore:

Proceed with the remaining steps on the "Restore SQL Server Database" page to complete the restoration of the SQL Server database.