beautypg.com

Changing resource groups on clustered sql servers, Recovering sql server data – Dell PowerVault DP600 User Manual

Page 68

background image

68

• When a server is removed from a cluster, DPM detects that a node has left the cluster and

the server now appears separate from the cluster with no data protected on it.

For example, assume you have a server cluster that contains four computers: Node1, Node2,

Node3, and Node4. You need to replace computer Node4 with a new computer named Node5.

You use the administration console for your cluster service to add Node5 to the cluster and

configure the resources that can be failed over to Node5.

DPM issues an alert that protection of the server cluster will fail until a protection agent is installed

on Node5. You install the protection agent on Node5.

You fail over the resources from Node4 to other nodes in the cluster. When no resources remain

on Node4, you remove it from the cluster. DPM detects the failovers and continues protection of

the cluster.

DPM detects that Node4 has left the cluster – it appears as a stand-alone node now. If it no

longer exists on the network, you can remove the record for this server in DPM Administrator

Console.

Changing Resource Groups on Clustered SQL Servers

A cluster node can have any number of resource groups. Moving a protected data source to a

resource group, between resource groups, or out of a resource group can cause protection job

failures. To successfully make any of those changes to resource group membership, perform the

following steps:

1. Stop existing protection of the data source. The data source could belong to a protection

group as a single data source on a protected server or as a data source as a member of a

resource group.

2. Begin protection of the data source according to its new status, either as a single data source

on a protected server or as a data source as a member of a resource group. This will allocate

a new replica for the data source.

Changing the name of a resource group will affect the protection of all data sources in the

resource group. To change the name of a resource group, perform the following steps:

1. Stop protection of the resource group.

2. Change the name of the resource group.

3. Begin protection of the resource group under its new name.

Recovering SQL Server Data

When you recover SQL Server data, you can choose from the following options:

• Recover the database to its original location
• Recover the database with a new name to its original location or to a different instance of

SQL Server

• Recover the database to a different instance of SQL Server