• |
These topics describe the general steps that you must take to complete a restore.
When restoring a VSS-based backup, be aware of the following:
• |
If you use the Copy Database Files to Target Directory option, do not remove the database from the group. |
a |
On the primary replica, select Suspend Data Movement for the database. |
2 |
On the Create Selection Set page, click Edit Plugin Options, and configure the applicable parameters depending on whether you are performing a VSS or VDI restore. |
3 |
In the AlwaysOn Availability Groups section, select the applicable check box (es): |
• |
Restore to the following AlwaysOn Availability Group: Enter the name of the group. |
• |
Enter the NetVault Backup Client Name on the AlwaysOn Availability Groups Primary Node (optional): Enter the name of the client that is running on the primary node. If you enter a name for a different node, the restore fails. If you are unsure which client is running on the primary node, use SQL Server Management Studio to determine which node is the primary node in the group. |
IMPORTANT: Although the second field is labeled optional, it is required in this scenario. If you enter the correct information and the database is already part of the group, but you do not select the Remove Primary Database from the AlwaysOn Availability Group Before Restore check box, the restore fails. If the database is not part of the group, you specify an incorrect name, and the plug-in is unable to check that the client resides on the primary replica, the plug-in restores the database. However, you cannot add the database to the group. If a failover to a different node occurs after the restore job is run and you have entered the primary client and group names, update the information stored in Restore Options to reflect the name of the new client. Otherwise, subsequent runs of the same restore job fail. |
5 |
In the Instance Name, If Restoring to an AlwaysOn Named Instance field, enter the name of the instance. |
TIP: Only enter the name of the instance. If you enter the fully qualified name, <HostName>\<InstanceName>, the plug-in ignores the hostname. |
6 |
8 |
Perform a restore from each secondary replica that was backed up by the Full Database backup performed in Step 7. |
9 |
3 |
On the Create Selection Set page, click Edit Plugin Options, and configure the applicable parameters depending on whether you are performing a VSS or VDI restore. |
4 |
In the Target Instance field in the Restore Options section, enter the name of the client running on the secondary replica. |
5 |
In the AlwaysOn Availability Groups section, select the applicable check boxes: |
6 |
In Restore to the following AlwaysOn Availability Group, enter the name of the group. |
7 |
In the Instance Name, If Restoring to an AlwaysOn Named Instance field, enter the name of the instance. |
TIP: Only enter the name of the instance. If you enter the fully qualified name, <HostName>\<InstanceName>, the plug-in ignores the hostname. |
8 |
11 |
13 |
Perform a restore of each secondary replica using the Full and Transaction Log backups completed in the previous step. |
14 |
The following procedure describes how to restore a VDI backup. This procedure is based on the example described in Example of creating a full VDI backup of an AlwaysOn Availability Group. The following procedure also requires that you restore Transaction Log backups, a process that was not included in the previous backup example.
1 |
In the Navigation pane, click Create Restore Job. |
2 |
In the saveset table on the Create Restore Job — Choose Saveset page, select the Full Backup of the primary replica that you are restoring, and click Next. |
3 |
On the Create Selection Set page, select the AlwaysOn Availability Group that you want to restore. |
4 |
Click Edit Plugin Options. |
5 |
6 |
In the AlwaysOn Availability Groups sections, select the Remove Primary Database from the AlwaysOn Availability Group Before Restore check box. |
7 |
8 |
In Job Name, specify a name for the job if you do not want to use the default setting. |
9 |
In the Target Client list, select the same Virtual Client that was the target of the backup. |
10 |
11 |
In the Navigation pane, click Create Restore Job. |
12 |
In the saveset table on the Create Restore Job — Choose Saveset page, select the Incremental Transaction Log backup of the primary replica that you are restoring, and click Next. |
13 |
On the Create Selection Set page, select the same AlwaysOn Availability Group and databases that you selected during the restore of the Full Backup. |
14 |
Click Edit Plugin Options. |
15 |
16 |
In the AlwaysOn Availability Groups section, select the Add Primary Database to the AlwaysOn Availability Group After Restore check box. |
17 |
In the Restore to the following AlwaysOn Availability Group field, enter the name of the group. |
18 |
In the Enter the NetVault Backup Client Name on the AlwaysOn Availability Groups Primary Node field, enter the name of the client on the primary node. |
19 |
If you are restoring the backup to a named SQL Server Instance, not the default instance, enter the name of the instance in the Instance Name, If Restoring to an AlwaysOn Named Instance field. |
TIP: Only enter the name of the instance. If you enter the fully qualified name, <HostName>\<InstanceName>, the plug-in ignores the hostname. |
20 |
21 |
In Job Name, specify a name for the job if you do not want to use the default setting. |
22 |
In the Target Client list, select the same Virtual Client that was the target of the backup. |
23 |
24 |
25 |
In Job Name, specify a name for the job. |
26 |
27 |
In the selection tree, open the first secondary replica that you are restoring, and then open the All Instances node. |
28 |
29 |
Enter the security information, enter the applicable login information, such as (local), for the Instance Name, and click OK. |
31 |
In the selection tree for the primary replica, select that databases that you are backing up. |
32 |
Run a VDI-based, Full Database backup. |
33 |
Using the same Selections set that you used for the Full Database backup, run an Incremental Transaction Log backup. |
34 |
In the Navigation pane, click Create Restore Job. |
35 |
In the saveset table on the Create Restore Job — Choose Saveset page, select the Full Backup of the primary replica that you completed Step 32, and click Next. |
36 |
On the Create Selection Set page, select the databases that you want to restore, and click Edit Plugin Options. |
37 |
38 |
In Job Name, specify a name for the job if you do not want to use the default setting. |
39 |
40 |
41 |
2 |
On the Create Selection Set page, click Edit Plugin Options, and configure the applicable parameters depending on whether you are performing a VSS or VDI restore. |
3 |
In the AlwaysOn Availability Groups section, clear the check box Remove Primary Database from the AlwaysOn Availability Group Before Restore. |
4 |
Select or clear the Add Primary Database to the AlwaysOn Availability Group After Restore check box, whichever is applicable. |
• |
Restore to the following AlwaysOn Availability Group: Enter the name of the group. |
• |
Enter the NetVault Backup Client Name on the AlwaysOn Availability Groups Primary Node (optional): Enter the name of the client that is running on the primary node. If you enter a name for a different node, the restore fails. If you are unsure which client is running on the primary node, use SQL Server Management Studio to determine which node is the primary node in the group. |
6 |
If you are restoring the backup to a named SQL Server Instance, not the default instance, enter the name of the instance in the Instance Name, If Restoring to an AlwaysOn Named Instance field. |
TIP: Only enter the name of the instance. If you enter the fully qualified name, <HostName>\<InstanceName>, the plug-in ignores the hostname. |
7 |
9 |
Perform a restore from each secondary replica that was backed up by the Full Database backup performed in Step 7. |
10 |
IMPORTANT: To make a copy of a database using the Full File and Filegroup Backup method, available only for VDI, it must be restored to a different SQL Server® Instance. When renaming a database during a VSS-based restore, the database files must also be relocated to an alternate directory. If the database files are not relocated to an alternate directory, the restore fails. This failure is because VSS does not let you rename the database without moving the data and log files to a different directory. When relocating data and log files for VSS-based restores, you can relocate the data files to one directory and the log files to a separate directory if both directories are different than the original. |
1 |
In the Navigation pane, click Create Restore Job, select Plug‑in for SQL Server from the Plugin Type list, select the applicable saveset, and click Next. |
2 |
3 |
In the Rename/Relocate dialog box, enter the applicable information: |
• |
Rename: Enter the new name. |
• |
Relocate: Enter the new path. |
With the plug-in’s VDI-based backup method, you can restore a database to an alternate instance of SQL Server® running on the database server. The procedure for performing this type of a restore is outlined in the following topic. This process does not support the use of AlwaysOn Availability Groups.
IMPORTANT: If you intend to restore a database to an alternate instance that resides on the same server and the original database still exists, use the Rename/Relocate option described previously in Renaming or relocating a database. Use this option to rename or move the datafiles to ensure that they do not overwrite or conflict with the same files in the original database. |
• |
Same version of SQL Server: Both the source instance from which the data was backed up and the target instance to which the data is to be restored must be running the same version of SQL Server. |
• |
Instance configured for access: The instance to which the database is to be restored must be accessible to the plug-in. To set up the instance for access, see Configuring authentication details. |
2 |
In the Navigation pane, click Create Restore Job, select Plug‑in for SQL Server from the Plugin Type list, select the applicable saveset, and click Next. |
3 |
On the Create Selection Set page, click Edit Plugin Options, and configure the restore options by following the instructions outlined in Restoring data from Online VDI backups. |
4 |
In addition, set the Target Instance parameter. |
5 |
Similar to the plug-in’s ability to restore databases to a different SQL Server Instance on the same database server, you can target a different SQL Server during the restore process. This process does not support the use of AlwaysOn Availability Groups.
This functionality is useful during disaster recovery operations. You can restore a database to a different SQL Server by using the steps provided in the following topics. You can also use this process to restore a NetVault Backup Virtual Client to a standalone NetVault Backup Client.
IMPORTANT: Microsoft’s VSS backup method does not support restoring a VSS-based backup to an alternate instance; therefore, restoring VSS-based backups to an alternate instance with Plug‑in for SQL Server is not supported. In a disaster recovery scenario, use this procedure to restore the master and the msdb database backups. After restoring the master database, restart the server. Restore and recover each individual database. |
• |
Same version of SQL Server installed: The SQL Server version must be the same as the version running on the existing database server. |
• |
NetVault Backup software and the Plug‑in for SQL Server installed: The same version of NetVault Backup software and the plug-in must be installed and configured on the new restore target. |
• |
Client added to the NetVault Backup Server: The target machine must be added to the NetVault Backup Server by using the Manage Clients page of the NetVault Backup WebUI. |
• |
Instance of SQL Server must exist on the new restore target: An instance of SQL Server must exist on the new restore target. This instance serves as the target of the relocation restore. Not only must this instance be properly set up and configured in SQL Server, it must also be accessible to the plug-in on the new restore target. To set up the instance for access, see Configuring authentication details. |
2 |
IMPORTANT: When you perform a restore to an alternate server, you cannot modify the name or destination of the restored master database. The master database is restored to the location of the current master database in the target for the restore. |
3 |
After restoring the master database, restart the server. |
a |
In the Navigation pane, click Create Restore Job, select Plug‑in for SQL Server from the Plugin Type list, select the applicable saveset, and click Next. |
b |
On the Create Selection Set page, click Edit Plugin Options, and configure the restore options by following the instructions outlined in Restoring data from Online VDI backups. |
c |
In addition, set the Target Instance parameter. |
NOTE: If you are restoring the default SQL Server® Instance to the alternate server, you can enter the name of the destination server, for example, MSSQLSERVER, for the Target Instance. |
d |
e |
In Job Name, specify a name for the job if you do not want to use the default setting. |
f |
In the Target Client list, select the new restore target. |
g |
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options. |
h |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center