Restore MSSQL Server Database from One Machine to Another
KB ID: 105
Challenge:
Restoring MSSQL Server Database from one machine to another machine.
Solution:
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:
- Schedule a SQL Server database backup locally in backup server A through the "Recovery" menu.
- Search for the appropriate "Backup Name -> Proceed to Restore Backup" and manually transfer the data to MACHINE B.
OR
- 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:
- After transferring the data to MACHINE B, edit the restore.conf file located in "<restored_location>/plugin/" folder.
- Open restore.conf and:
- Change the SqlInstanceName attribute value to MACHINE B SQL Server Instance name.
- Log in to MACHINE B SQL Server Instance at least once from the "SQL Server connection properties" page.
- Change the ClientIdentity attribute value to MACHINE B StoreGrid Identity.
- Save and close the file.
3. Check Database Files:
- Ensure that the database to be restored does not exist in the Mapped Drive of MACHINE B.
- 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:
- In the Vembu NetworkBackup WebConsole, select "Restore" from the top menu.
- On the "List Of Backup For Restore" page, click the Restore icon in the Action Column of the desired SQL backup schedule.
- Choose the option to restore SQL Server database from previously restored data.
- 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.
Related Articles
Migration of Vembu BDR v3.6 and Above [Server Running MySQL, Mongo] from One Machine to Another
KB ID: 29 Purpose: This guide outlines the process for migrating a BDRSuite server from one machine to another in both physical and virtual environments. Machines: Machine A: Old Backup Server machine. Machine B: New Backup Server machine. Solution: ...
Configuring MS SQL Database Backup
Configuring Microsoft SQL Database Backup ensures the reliable protection of your SQL databases, safeguarding critical data and ensuring business continuity. With customizable backup schedules, retention policies, and flexible recovery options, this ...
Step-by-Step Guide: Restoring a Specific SQL Database from Image Backup for MS SQL Database Recovery
KB ID: 62 The need arises to restore a specific SQL Database from an Image Backup, specifically focusing on MS SQL Database recovery. Solution: Follow the steps below for the MS SQL DB Recovery: Step 1: Mount Vembu Virtual Drive and attach the VHD ...
Can I restore only the database from Windows Image Backup?
Yes, you can restore only the database from a Windows Image Backup using application-item level recovery for Microsoft applications - Exchange Server, SQL Server, Active Directory and SharePoint or by mounting the backup and accessing the required ...
Can I restore only the database from VMware Backup?
Yes, you can restore only the database from a VM Backup using application-item level recovery for Microsoft applications - Exchange Server, SQL Server, Active Directory and SharePoint or by mounting the backup and accessing the required database ...