Adding new disk resource to SQL cluster

운영 중인 Cluster에 Disk 리소스를 추가 한 후 해당 디스크 리소스를 SQL Server 그룹에서 사용하기 위해서는 해당 서비스를 Offline으로 변경 해야만 합니다.
즉 SQL Serverivce가 중지 되어야 한다는 것이지요.

최근에 Cluster를 설치 할 기회도 없고 테스트 할 수 있는 머신이 없어서 긴가 민가해서 위 내용에 대한 검증을 위해서 여러 문서를 찾다가 아래의 웹 사이트를 발견 하였습니다.

Adding new disk resource to cluster
http://sqllearnings.blogspot.com/2010/01/adding-new-disk-resource-to-cluster.html

 Adding New Disk as Cluster Resource:

• Launch Cluster Administrator on Active Node.

• Go to SQLServer Group.

• Right click in left pane, select New.

• Select Resource.

• Give it a Name, for example Disk T:

• Select Resource Type, Physical Disk.

•  Click Next.

•  Select the possible owners for the resource, in my case since it is only two node cluster both nodes get added automatically.

•  Click Next.

•  Select dependencies; that is which resources should be online before Disk T is brought online. This option for disk is not required unless you are using Mount Points; then you would want to make sure Mount Point Disk is listed as a dependencies.

• After adding dependencies, click Next.

• From the Drop Down select the new Physical Disk.

• Click Finish.

 

Adding New Disk as Dependencies to SQL Server:

• Launch Cluster Administrator on Active Node.

• Go to SQLServer Group.

• Right Click on SQL Server, select Take Offline.

• Right Click on SQL Server, select Properties.

• Select "Dependencies" from Tabs at top.

• Click Modify.

• Select the New Disk Resource that was just added.

• Click OK on both windows to get back to Cluster Admin console.

• Right Click on SQL Server, select Bring Online.

감사합니다^^