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


48 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. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
      Network Security Projects for CSE

      JavaScript Training in Chennai

      Project Centers in Chennai

      JavaScript Training in Chennai

      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
  5. I really loved reading your blog. It was very well authored and easy to understand. Unlike other blogs I have read which are really not that good.Thanks alot! A1Pioneer.com

    ReplyDelete
  6. In Windows 8.1 the Start screen gets a noteworthy overhaul to make it less demanding to redo, marketplaces

    ReplyDelete
  7. This curiosity you describe is fantastic

    ReplyDelete
  8. Impartial and unbiased blog, making it pleasurable for the audience to read.
    Removals service

    ReplyDelete
  9. It would appear that the author has put a considerable measure of diligent work into this.
    man with van services

    ReplyDelete

  10. tutuapp vip
    tutuapp apk
    tutu app apk
    tutuapp install
    tutuapp download
    I loved the way you discuss the topic great work thanks for the share, Let me share this.

    ReplyDelete
  11. vshare
    vshare download
    vshare market
    vshare apk
    vshare helper
    vshare ios
    It was very well authored and easy to understand. Unlike other blogs I have read which are really not that good.

    ReplyDelete
  12. They can be installed and used on Windows 98 and all the later Windows operating systems.realistic text to voice

    ReplyDelete
  13. As I mentioned earlier, there is plenty of Microsoft Help out there. In fact your Microsoft Office software package come preloaded with Microsoft Help. reset windows 10 password

    ReplyDelete
  14. I started playing at nice slot machine tips after reading reviews from other players and I see that it’s not for nothing. Judging by the number of reviews on the Internet, it seems that only the lazy one did not play here)) Well, by the number of reviews and topics on the forums one can definitely say that this is one of the most popular players.

    ReplyDelete
  15. That is really nice to hear. thank you for the update and good luck. Hauling Services

    ReplyDelete
  16. Each has its use. Quilted Moving blankets usually come in 72 x 80 inches size and differ depending on the outer fabric and amount of filler, the heavier the blankets the more filer they have and the more protection they offer. شركات نقل الاثاث

    ReplyDelete
  17. whatsapp
    leapdroid 2019
    kmplayer for windows
    audacity for windows
    kingroot for pc
    The screenshot shared by the blog site shows a separate section for Facebook Pay in WhatsApp wherein users can add bank accounts and other payment methods.

    ReplyDelete
  18. Thus there are various methods by which you can Save Money When Moving. Make a rough calculation about the payment you can afford Relocation services

    ReplyDelete

  19. www.aolmail.com
    AOL, previously known as America Online, offers your business access to e mail, information, companies and more.

    ReplyDelete

  20. really infomative and eduvcative article thanks publisher for sharing this info with us massage gaming chair with footrest
    whatsaup flippzilla

    ReplyDelete
  21. Marketing Automation works through the process of automated tracking and monitoring of individual prospects on the company's website. The marketing team can use the various automation tools to decipher prospect's interests, needs and goals. https://updigital.ca

    ReplyDelete