SQL Server high-availability failover (4)

Two SQL Servers configure iSCSI virtual disks

In the previous article we used iSCSI target software to create three iSCSI virtual disks on Dc-iscsci, below we will show you how Sql-cl01 (HSR1 50) and Sql-cl02 (HSR2 51) Access these iSCSI virtual disks.

SQL-CL01 and SQL-CL02 can use the iSCSI protocol to access virtual iSCSI disks on Dc-iscsci, because the iSCSI protocol is already built into Windows Server 2008. So we don't need to install the iSCSI client software on SQL-CL01 and sql-cl02. If the operating systems for SQL-CL01 and SQL-CL02 are Windows Server 2003, then we need to install iSCSI initiators on Server1 and Server2.

Let's take Sql-cl01 (HSR1 50) as an example to show you how to access iSCSI disks on Windows Server R2, and we perform an "iSCSI initiator" in SQL-CL01 's administrative tools. As shown below, the system prompts us that the iSCSI service is not running, if we need to start the iSCSI service and set the service to start automatically, we select "Yes".

On the destination, enter the IP address of the iSCSI server 192.168.2.52 (ABC-DC), and then click Quick Links.

Note If the status is enabled on the target iSCSI

Status: Linked

Switch to the Discovery tab and we see the address and status of the iSCSI server linked to

Then switch to volumes and devices, click Automatic Configuration, and automatically configure the virtual disk that you just linked to

SQL-CL01 (HSR 50) with iSCSI initiators connected to iSCSI disks on ABC-DC, iSCSI disks can be managed in the SQL-CL01 Disk Manager.

, in Sql-cl01 's Disk management, we find that there are three more disks in the SQL-CL01, a 30G, 10G, 3G three disks that are the iSCSI virtual disks created on ABC-DC

Then we turn on disk Management for Server1 (HSR IP 50) and view the disk status

We have three iSCSI virtual disks online, initialized, partitioned, and formatted. is shown

The 5G iSCSI disk is assigned the S drive letter, and the S disk will be used to store the SQL data.

The 2G iSCSI disk is assigned the L drive letter, and the L disk is used as the log disk for SQL storage.

The 2G iSCSI disk is assigned the Q-drive letter, and the Q-drive is used as the quorum disk for the cluster.

Here is the first disk named Q disk as the quorum disk for the cluster

After all configuration is complete sql-cl01 (HSR 50) such as (L SQL log disk, q quorum disk, S SQL data disk)

After Sql-cl01 (HSR 50) is set up, we need to do the same iSCSI setup on sql-cl02 (HSR 51) and assign the same drive letter to the three iSCSI virtual disks on ABC-DC, so

You can access the previously created iSCSI disks on SQL-CL01 and SQL-CL02.

Sql-cl02 (HSR 51) This one doesn't need to be initialized, partitioned, formatted, just online.

Online

If the E-drive is changed, the letter is consistent with HSR 50

Two SQL Servers have added virtual Disk Management

SQL Server high-availability failover (4)