立即与支持人员聊天
与支持团队交流

NetVault Plug-in for SQL Server 10.0.6 - User Guide

Introducing Dell™ NetVault™ Backup Plug-in for SQL Server® Planning your SQL Server deployment Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data Troubleshooting

Finalizing and submitting the job

Using other restore procedures

All options available for a restore with the plug-in are also available in high-availability (SQL Server Failover Cluster and AlwaysOn Availability Group) environments. Data selection is performed the same way. The difference is that restorable backups of a Virtual Client are displayed on the Create Restore Job — Choose Saveset page under the name of the Virtual Client, not the specific NetVault Backup Client or node that was active during each backup. When a restore job is initiated, NetVault Backup communicates with all member Clients to determine which machine controls the cluster, and then targets this machine for the restore.
NOTE: During a restore, run the process using the node for the Virtual Client. Do not use one of the nodes for an individual client in the cluster to run the process. If you open or expand one of the nodes and drill down through the hierarchy, you might see a dimmed SQL Server Instance identified as local. While the system might use this instance in maintaining log information, do not run any processes at this level.
Unless you want to use SQL Server Management Studio to add the primary replica to the group, select the Add Primary Database to the AlwaysOn Availability Group After Restore check box.
If you select With NO RECOVERY for the Restore Type of the primary replica, do not select the Add Primary Database to the AlwaysOn Availability Group After Restore check box. You must complete the recovery before you can add the database to the group.

Restoring data in an AlwaysOn Availability Group

All options available for a restore with the plug-in are also available in high-availability (SQL Server Failover Cluster and AlwaysOn Availability Group) environments. Data selection is performed the same way. The difference is that restorable backups of a Virtual Client are displayed on the Create Restore Job — Choose Saveset page under the name of the Virtual Client, not the specific NetVault Backup Client or node that was active during each backup. When a restore job is initiated, NetVault Backup communicates with all member Clients to determine which machine controls the cluster, and then targets this machine for the restore.
NOTE: During a restore, run the process using the node for the Virtual Client. Do not use one of the nodes for an individual client in the cluster to run the process. If you open or expand one of the nodes and drill down through the hierarchy, you might see a dimmed SQL Server Instance identified as local. While the system might use this instance in maintaining log information, do not run any processes at this level.
Unless you want to use SQL Server Management Studio to add the primary replica to the group, select the Add Primary Database to the AlwaysOn Availability Group After Restore check box.
If you select With NO RECOVERY for the Restore Type of the primary replica, do not select the Add Primary Database to the AlwaysOn Availability Group After Restore check box. You must complete the recovery before you can add the database to the group.

Restoring data in an AlwaysOn Availability Group

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 boxes:
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: Both fields are optional; however, if you choose to use these fields, Dell recommends that you complete both. If you complete one field and the plug-in is unable to determine the name for the other field, the restore fails.

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.
7
Perform a restore from each secondary replica that was backed up by the Full Database backup performed in Step 6.
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.
12
Perform a restore of each secondary replica using the Full and Transaction Log backups completed in the previous step.
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
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
In the Restore Type section, select With NO RECOVERY.
6
In the AlwaysOn Availability Groups sections, select the Remove Database Secondary Copies from the AlwaysOn Availability Group Before Restore and Remove Primary Database from the AlwaysOn Availability Group Before Restore check boxes.
Do not select the Add Primary Database to the AlwaysOn Availability Group After Restore because you selected the With NO RECOVERY option.
7
Click Ok to save the settings, and then click Next.
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
Click Save & Submit, and use the Job Status page to monitor progress.
11
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
In the Restore Type section, select With RECOVERY.
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
Click Ok to save the settings, and then click Next.
20
In Job Name, specify a name for the job if you do not want to use the default setting.
21
In the Target Client list, select the same Virtual Client that was the target of the backup.
22
Click Save & Submit, and use the Job Status page to monitor progress.
23
In the Navigation pane, click Create Backup Job.
24
In Job Name, specify a name for the job.
25
Next to the Selections list, click Create New.
26
In the selection tree, open the first secondary replica that you are restoring, and the open the All Instances node.
27
Select the All Instances node, and select Configure from the Actions menu.
29
Repeat Step 26 through Step 28 for each secondary replica.
30
In the selection tree for the primary replica, select that databases that you are backing up.
31
Run a VDI-based, Full Database backup.
32
Using the same Selections set that you used for the Full Database backup, run an Incremental Transaction Log backup.
33
34
In the saveset table on the Create Restore Job — Choose Saveset page, select the Full Backup of the primary replica that you completed Step 31, and click Next.
35
On the Create Selection Set page, select the databases that you want to restore, and click Edit Plugin Options.
36
In the Restore Type section, select With NO RECOVERY, click Ok, and then click Next.
37
In Job Name, specify a name for the job if you do not want to use the default setting.
38
In the Target Client list, select the Virtual Client name of the secondary replica.
39
Click Save & Submit, and use the Job Status page to monitor progress.
40
Repeat Step 33 through Step 39 to restore the Incremental Transaction Log backup from the primary replica to the secondary replica.
42
Repeat Step 33 through Step 41 for each secondary replica that is part of the group.
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 following check boxes:
4
Select or clear the Add Primary Database to the AlwaysOn Availability Group After Restore check box, whichever is applicable.
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.
8
Perform a restore from each secondary replica that was backed up by the Full Database backup performed in Step 6.
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级