question

German avatar image
German asked

Does adding a new LUN to a multi-instance cluster affect the rest of the instances?

I'm looking into building a shared SQL environment using two servers as a 2-node Active/Active cluster, and attached to a NetApp SAN. I'm planning on installing SQL Server 2008 R2 on Windows Server 2008 R2 64-bit.

My question is the following: Let's suppose I have 2 SQL Server instances per server/node (4 in total). If I want to add a third by adding new LUNs to the cluster... do I have to bring down the rest of the SQL Server instances on the same node? Or is that something that can be done on the fly without having to bounce the rest of the instances? (I know I do have to bounce SSIS)

Thanks in advance for any tip!

sql-server-2008clustering
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Jason Cumberland avatar image
Jason Cumberland answered

This may depend on your SAN and driver but with our environment you follow these steps with windows 2008 R1 and SQL 2008 SP1.

  • present the LUN to the nodes
  • re-scan in Dusk Management on each node and verify volume shows up
  • create partition and format from one of the nodes
  • use failover cluster management to re-validate the cluster, not letting it take the cluster resources offline for the tests
  • use failover cluster management to add the storage to the cluster
  • run sql install
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.