SQL Server 2005 Cluster replacement storage

Why write this article, mainly because of the case of replacing storage on the cluster, such as a small failure of the original storage, fear of data loss, you must change the storage in the cluster into a new storage. So we set up an experimental environment to verify the implementation process. This environment is a Windows Server 2003+sql Server 2005-based environment. Later, a document related to Windows Server 2008+ SQL Server 2008 is published.

Quorum information is recorded in the quorum disk, as shown in:

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384484qplf.png "width=" 307 "height=" 213 "/>

And the data disk is stored in the system database and other information, as shown in:

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_14063844842kq5.png "width=" 593 "height=" 351 "/>

The key is the information in this s disk.

First: Store the LUNs for the new quorum disk and the data disk, and map to two nodes. You can see the same disk information on all two nodes.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_140638448549oh.png "height=" 294 "/>

First partition on a node, formatting and other operations, in order to be separated from the earlier quorum and data disk, in this arbitration for the P-disk, the data is the T disk, the other node rescan can, do not need to restart, and then add the drive letter, as shown in:

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384485c48l.png "height=" 346 "/>650) this.width=650;" Title= " Image "Style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px; padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment /201407/26/382644_14063844858gey.png "height=" 244 "/>

To replace the quorum disk in the cluster:

The first step is to join the quorum disk to the cluster group, as shown in the other operations by default.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384485xs5k.png "height=" 249 "/>

Then, edit the properties of the Windows cluster, and the quorum---Specify a new quorum disk. As shown in the following:

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384485xpbs.png "height=" 366 "/>650) this.width=650;" Title= " Image "Style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px; padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment /201407/26/382644_1406384485ymmt.png "height=" 368 "/>

Note : You cannot start the Cluster service because the quorum disk is not available, use the /fixquorum switch to start the Cluster service. You can then change the quorum disk. As shown in the following:

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://img1.51cto.com/attachment/201407/26/382644_1406384485QRkg.png "height=" 244 "/>

This command is only used when the cluster fails to start because of quorum reasons, after the quorum disk is successfully set, remove this parameter, and then restart the Cluster service. You can then delete the original quorum disk, or leave it as a backup.

Replacing a data disk in a cluster

First, add the new data disk to the SQL Server resource group, as shown in the other default.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384485pmsy.png "height=" 218 "/>

Next, you need to make the SQL Server service aware of this disk, depending on the SQL Server dependency, as shown in adding a new disk to the dependency, and carefully examining the dependencies of the SQL Server-related services, I use the SQL Server fulltext and SQL Server services, note that the service is going offline before adding resource dependencies, and then the service is online again.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384486usuw.png "height=" 413 "/>650) this.width=650;" Title= " Image "Style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px; padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment /201407/26/382644_14063844869nzj.png "height=" 412 "/>

At this point, SQL Server will be able to identify the newly added disk, you can do the data backup and so on. As shown in the following:

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_14063844869j4p.png "height=" 134 "/>

Then, copy the data and copy all the data from the S: Disk to T:.

The following steps are as follows:

1. Only one node is guaranteed to power on, and the other node shuts down to allow all disk resources to switch to a single node. Easy to operate.

2. Stop the SQL Server service, otherwise, the file cannot be copied.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384486tc49.png "height=" 197 "/>

Because the contents of the database are stored in the S-disk, it must be shut down before replication can take place. varies by data volume and storage performance time. All content, select Copy all.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384486bfjp.png "height=" 409 "/>

Immediately after that, modify the disk disc label:

1. Open Disk Manager, view all disks are recognized, and record the disk number as shown in:

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384486o5i9.png "height=" 453 "/>

The original quorum disk is 1, the original database is Disk 2, the new quorum disk is diskette 3, and the new data disk is Disk 4.

2. Open the registry and locate the following location:

Hklm/system/currentcontrolset/services/clusdisk/parameters/signatures the key value, find all the original storage shared disk number

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_14063844866le9.png "height=" 390 "/>

Here, we mainly record the original data disk number, disk 2, corresponding to the 7fe3e998.

650) this.width=650; "title=" image "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment/201407/26/382644_ 1406384487a1h1.png "height=" 357 "/>

3, the original data disk number corresponding to the new disk, that is, change the disk signature.

But helpless did not find the Dumpcfg.exe command, this command should be included in the Windows 2000 Resource Kit, but it is not found, I stole a lazy, directly modify the registry. (It is strongly recommended to use the Dumpcfg.exe command operation), do not know the direct modification of the registry, there is any hidden danger, I hope to have a friend to know to explain, or tell me where to download to the Dumpcfg.exe program.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384487wifq.png "height=" 368 "/>

To modify the dependency relationship:

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_14063844878mhd.png "height=" 286 "/>650) this.width=650;" Title= " Image "Style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px; padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment /201407/26/382644_1406384487y1db.png "height=" 288 "/>

Then, start all nodes, delete the original data disk s disk, (delete the resource must require all nodes to boot)

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384487uxng.png "height=" 417 "/>

Immediately thereafter, the other node shuts down again, leaving only one node to power on, and modifying the new data disk with the drive letter as the S disk.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// Img1.51cto.com/attachment/201407/26/382644_1406384487oxws.png "height=" 275 "/>

Then, this node shuts down and then turns on the second node to see if the drive letter is s: if not, you need to modify the consistency. Then, all nodes are powered on.

Finally, bring the SQL Server service and the Proxy service online, as shown in the following:

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://img1.51cto.com/attachment/201407/26/382644_14063844873ie5.png "height="/>

At this point, the operation is done.

Other storage in the cluster is replaced in the same way. After you have joined the cluster, modify the disk information (signature). For example, if the MSDTC resource is present, it is the same way of adding a new disk to the cluster, stopping the service, copying the data from the source disk to the new disk, modifying the disk signature, deleting the source disk, and modifying the drive letter. Start the service, OK.

Also, be aware that:

Or, in some cases, you need to add the SQL Server service account to the SQL Server and OLAP folders, and have the SQL Server service account have all the permissions for that folder.

Reference: http://tech.diannaodian.com/dw/data/sql/2012/0610/181991.html

After the experiment, Microsoft's operation is to update the disk signature with the Dumpcfg.exe command, but it doesn't have to be. If you are on a SQL Server 2008 environment, you can refer to the following discussion:

http://social.microsoft.com/forums/cs-cz/24e3cbf1-43af-412d-909a-1a68c72fe527/windows-2008-server-r2-

Http://social.msdn.microsoft.com/Forums/zh-CN/c263cd5c-1b2b-48e3-95df-96805bc1e579?forum=sqlserverzhchs

This article is from the "Duffy" blog, make sure to keep this source http://dufei.blog.51cto.com/382644/1530567

SQL Server 2005 Cluster replacement storage