Pages

Wednesday, 28 March 2012

Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk

We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have to move the MSDTC disk to new SAN drive as we are going to decommission the existing SAN. In this post  I will explain the steps that we have followed in our environment to move the MSDTC disk to new SAN.The same steps can be followed for configuring MSDTC in a new cluster environment.

From the current host server(the node where quorum drive visible) ,open the Failover Cluster Management. In the left pane expand the Services and Application group and select the MS-DTC resource. From the summery window note down the Server network name and IP address to use in our later steps.

The next step is to get  the new SAN disk in the cluster. To add the disk to the cluster follow the steps given below:
  • Open the windows disk manager.
  • Right click the new disk  in Windows Disk Management and select online.
  • Right click again and select initialize.
  • Finally format it by right clicking the disk and selecting New Simple Volume.
  • This will open Simple Volume Wizard. Provide the new drive letter(For Example U) and label for the disk.
  • In the Cluster Manager ,select the storage in the  left pane.
  • Select the Add Disk in the Action pane and select the proposed new disk.
At this point we can see this disk under the available storage group. Now everything is ready to make the move. Unfortunately we can't move existing MSDTC to the new disk directly.The only option is delete the existing one and add new MSDTC
Follow the below steps to delete and add new MSDTC resource:
  • In the cluster manager ,expand the services and applications
  • Right click  the MSDTC  group and select Delete.
  • Now the existing MSDTC  disk (in our environment X drive) will be available under the available storage.
  • Select the old disk (X drive) under the storage and click on change drive letter option available in the activity pane
  • Select None as new drive letter and click Ok button
  • Select the new disk ( U drive ) under the storage  and click on change drive letter option available in the activity pane
  • Select X as new drive letter and click Ok button
    •    The last four  steps are done to keep the drive letter for new disk as same as the old one. These four steps are not mandatory to perform.
  • Right click on the Services and Application and select Configure Services or Application option
  • This will open the high availability wizard screen.
  • Select next which will list Services or application that can be configured for the high availability.Select the Distributed Transaction Coordinator(DTC)















  • Select Next which will open the client access point configuration screen as given below.Enter the network name and IP address which we have noted down in the first step.















  • Select Next,which will open the storage configuration screen.This will list all the disk available under the available storage group. Select the appropriate disk and click Next


On clicking Next, it will directed into the confirmation screen and click again on Next will complete configuration. Now the MSDTC is configured in the SAN disk and can be verified by opening the disk in the windows explorer. Now we should be able to see the MSDTC  folder inside the new drive which confirms the movement. Now bring this service online.Set the preferred owner through the properties window and test the failover.

In the later post I will be explaining about quorum disk and System/user database movement to the new SAN array.

If you liked this post, do like my page on FaceBook at http://www.facebook.com/practicalSqlDba


6 comments:

  1. Thanks, I am really looking forward to see quorum disk and System/user database movement to the new SAN array

    ReplyDelete
    Replies
    1. sợ hãi, Đấu Tông cường giả, đặc biệt là một cái ngũ tinh Đấu Tông cường giả, dĩ nhiên cũng bị giết như vậy, những người còn lại đã muốn chạy trốn, cũng không có tâm tư tái chiến.
      đồng tâm
      game mu
      cho thuê nhà trọ
      cho thuê phòng trọ
      nhac san cuc manh
      số điện thoại tư vấn pháp luật miễn phí
      văn phòng luật
      tổng đài tư vấn pháp luật
      dịch vụ thành lập công ty trọn gói
      http://we-cooking.com/
      chém gió
      - Tử Điện Mãng, Yêu Cơ, Thông Thiên Thử, Khiếu Thiên Hổ, ngăn lại bọn hắn, một người cũng đừng buông tha.

      Nhạc Thành ở giữa không trung nói, nếu để Huyễn Linh môn người có thực lực mạnh nhất chạy thoát, thì về sau sẽ có rất nhiều phiền toái.

      Kỳ thật người này đào tẩu Nhạc Thành cũng không phải để ý, về sau cái này cũng không liên quan đến Nhạc Thành, chỉ là bây giờ Tư Mã Yên Nhiên cùng Đỗ Mật Nhi, Âu Dương Phiên Tình ba cô gái cũng ở đảo Tả Tinh, Nhạc Thành không muốn sảy ra cái gì đối với bọu Thiên Hổ lên tiếng, sau đó lần nữa nhảy xuống, lập tức để mọi người vây quanh bên trong, bây giờ Huyễn Linh môn người có thực lực mạnh nhất tu vi cũng chỉ là tứ tinh Đấu Tông mà thôi, những Đấu Tông khác cùng Đấu Hoàng căn bản không đủ lực, chỉ cần có Khiếu Thiên Hổ cùng Yêu Cơ hoàn toàn có thể toàn bộ giết chết, huống chi còn có Linh Cảnh tông bốn Đấu Tông, Huyễn Linh môn cường giả bây giờ nếu muốn chạy cũng

      Delete
  2. Thanks.This is the exact process that we have followed in our environment and it went well.We did the user database also with very minimal downtime.I will post that too

    ReplyDelete
  3. Thanks very informative post, would you mind posting the process for moving user databases too?

    ReplyDelete
    Replies
    1. It is already published
      http://www.practicalsqldba.com/2012/06/sql-server-moving-system-resource-and.html

      Thanks
      Nelson
      www.PracticalSqlDba.com

      Delete
  4. Is it necessary to backup or move the existing msdtc data or does sql not care and start a new DTC file when you restart the SQL service?
    Is there anything that would be required from the "old DTC" from the old cluster resource to see upon firing SQL service back up?

    ReplyDelete