류짱:Beyond MySelf

운영 중인 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.


감사합니다^^

Comment 0