Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

How to use sf(with cluster option for MS CLUSTER)on mscs

Created: 11 Mar 2013 • Updated: 22 Mar 2013 | 27 comments
RickyLeung's picture
This issue has been solved. See solution.

HI

My client's enviroment:

WIN2008R2,mscs for sqlserver 2005,has tow disk arrays.

I want to configure tow-array with mscs,but they has installed mscs and sqlserver.....so ,can I create dg and mirror volume to join the mscs,and copy sql data\log file to new volume(i will shutdown sql service first) ?

if yes,how to setup?

if no,what is the better way to migrate original data to sfw mirror volume?

because the system is critical system,can't be reinstalled mscs and sqlserver!

thanks. hope everyone know what i say!

Regards

RL

Operating Systems:

Comments 27 CommentsJump to latest comment

mikebounds's picture

This should work and you will need to shutdown SQL service before copying so SQL data is not changing while you are copying it.  You will also need to create VMDg resource in MSCS (you need to have MSCS Cluster option of SFW software installed for VMDg resource type to be available).  If there is a lot of data and it will take a long time to copy, you could convert partition to a Symantec volume and diskgroup, but this needs to be done while SQL is offline too.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

RickyLeung's picture

Hi mike

thanks for your reply.I will make SQL offline before coping.

I installed MSCS CLUSTER OPTION,and create SFW DG and mirror volume,but it don't appear in MSCS.I don't know why.

Regards

Ricky

RickyLeung's picture

I follow the guide:

Failover Cluster Management--> Add a resource -->More resources > Add Volume Manager Disk Group

But I can't see any VMDG!

mikebounds's picture

This suggests MSCS Cluster Option did not work - try going into Control Panel and Add & Remove programs and choose Change for SFW to make sure MSCS Cluster option is selected.  If I remember correctly I think this puts a VMDg dll in the windows directory or subdirectory which is what MSCS picks up.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

RickyLeung's picture

HI mike

I am sure I installed MCSC CLUSTER OPTION.

Maybe the VMDG Service don't work?I will try to reinstall MSCS cluster option.

thanks.

Ricky

Donald Cook's picture

Hello Ricky,

If you are using Storage Foundation, the fact that you are using 2 storage arrays is %100 transparent to the Cluster & SQL. If you already have the original disk group clustered. No additional action is needed with the cluster. You can move to the new array with SQL running. Please follow the technote below.

How to perform data migration from an existing array to a new array using SFW
http://www.symantec.com/docs/TECH87823

RickyLeung's picture

Hello Donald

Thanks for your reply.But we did not installed SFW software,and the MSCS and SQL is running,so we can't migrate SQL data to new arrays with SQL running.

Reagrds

Ricky

mikebounds's picture

Ricky - have a look at the following 2 technotes:

How to register Resource Types for VERITAS Volume Manager for Windows 2000, 2003, 2008, VERITAS Volume Replicator for Windows 2000, 2003, 2008, and VERITAS Storage Foundation for Windows in a Microsoft Cluster environment -
http://www.symantec.com/business/support/index?page=content&id=TECH33400

Volume Manager Disk Group resource type needs to be re-added when a Windows Server Failover cluster is destroyed -
http://www.symantec.com/business/support/index?page=content&id=TECH64813

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

Donald Cook's picture

Hello Ricky,

I’m a little confused. The VMDg resource in a Microsoft Cluster is a feature of Storage Foundation.  You stated above that you do not have Storage Foundation installed.  If you do not have Storage Foundation installed than the VmDG resource is not an option available to you.  All of the information being provided to you above by Mike Bounds implies that you have Storage Foundation installed.  If you do not have Storage Foundation installed Windows will not read any Storage Foundation Dynamic Disk Groups (SFW DG). The Storage Foundation installation adds the VMDG as a resource type available in the Microsoft Cluster.

Storage Foundation gives you the following abilities:

-Add new disks to a disk group and mirror
-Migrate data from array to array with no down time
-The ability to add VMDg resources into the Microsoft cluster

Without Storage Foundation you are using regular Microsoft basic disks. To migrate with basic disks you will need to.

-add new LUNs to the server
-schedule down time
-backup and restore to the new LUNs
- create a new regular Microsoft disk resource in the cluster

If Storage Foundation is not installed, Microsoft would need to provide you additional assistance for this process.

Kind regards,
Donald

RickyLeung's picture

I fix the issue by reinstalling sfw with mscs cluster option.

But I add VMDG resourece to MSCS,shutdown SQL and copy datafile/log file to new volume,the MSDTC serivce can't be online!

someone say that data miragetation from original disk  to new volume would make MSDTC can't be online,even if we use MSCS without SFW!

It is right?and how to solve problem?any action should be required?

thanks.

ricky

mikebounds's picture

Which resources are working and which are not (VmDg, SQL service, MSDTC service etc).  Are you using the same drive letters/folder mounts for SFW that you were using for non-SFW.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

RickyLeung's picture

Hi mike

when I make MSDTC offline,other resources are working;try to online MSDTC,it will failed,and other resources will be offline. ..

Ricky

mikebounds's picture

Are you using the same drive letters/folder mounts for SFW that you were using for non-SFW.

i.e supposing SQL was on D:, then you should have stopped SQL and copied all data to say E: on SFW volume, then you should have unassigned D: on old non-SFW partition and reassign SFW volume to D:, so from an SQL/MSDTC perspective, nothing has changed.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

RickyLeung's picture

Mike,I did as you say.nothing has changed.

Maybe MSCS and MSDTC depend on what i missed?

RickyLeung's picture

I use the same mount point and folder as the original.

mikebounds's picture

This should work then - maybe you didn't copy some hidden files as if all files are the same, then SQL will be unaware of the change.  What you are doing is similar to a restore from a backup after a disk failure where you are copying files to different storage, but so long as the files are the same, the change in underlying storage makes no difference.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

RickyLeung's picture

mike

but I deteted MSDTC and recreate it that reside basic disk,all resources are working.

If it resides on dynamic DG,it will failed.

mikebounds's picture

Is SQL working on new SFW volume and is it just MSDTC that is not working?

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

RickyLeung's picture

HI.mike.

If MSDTC reside on VMDG,it is not work;if basic disk,it is working.

mikebounds's picture

I don't know that much about MSDTC - I only used it once as most databases I worked with just had SQL without MSDTC and I can't even remember if MSDTC had its own storage or whether it uses the SQL database.  Have you migrated the SQL database onto VMDg, and if so is SQL working, even though MSDTC is not.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

RickyLeung's picture

To mike &  Donald

Are you symantec empolyee?

I am doing POC to my client....but encounter the problem.

I read SFW admin guide,and it teach me how to install and configure SFW in a new environment,but did not mention of MSDTC...Want to know wheter can it be supported by VMDG?

Who can give me a result?

Regards

Ricky

mikebounds's picture

I no longer work for Symantec, but I was a consultant there for 10 years.  VMDg does not have a list of supported applications, because it is no different from Windows LDM and in fact Windows LDM is actually a cut-down OEM version of SFW.  So any application will work with VMDg and actually MSDTC is specifically mention in "Veritas Storage Foundation and High Availability Solutions Quick Recovery and Microsoft Clustering Solutions Guide for Microsoft SQL" where there is a "Creating the MSDTC resource" section for MSCS on SFW.

Maybe when you copy files in Windows, there is a difference in the copied version and MSDTC is senstive to this - you could try copying to a different basic disk to verify this and if the copy doesn't work you will have to look at different ways of copying using backup and restore rather than copying in Explorer.

Mike

 

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

mikebounds's picture

This link - http://www.ryanjadams.com/2011/07/move-cluster-msdtc/#axzz2NPqfO4bl says you should recreate the MSDTC resource in MSCS.  This could be because the dependency in MSCS changes from depending on a basic disk to depending on a different basic disk (or a VMDg resource in your case), so you could just try changing dependency if you haven't already, or recreate the MSDTC resource.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

Donald Cook's picture

Hello Ricky,

I am a current Symantec Employee. I agree with Mike. MSDTC is supported while using a VMDg resource for disk management. At this point, I would recommend that you open a technical support case so that we may provide you some additional assistance.

Contact Business Support Via Phone
http://www.symantec.com/support/techsupp_contact_phone.jsp

The support for clustering MSDTC in a Microsoft Cluster would need to be provided by Microsoft. However, it is a supported configuration to cluster MSDTC on top of a VMDg Resource.

Symantec and Microsoft Supportability statement
http://www.symantec.com/docs/TECH159728

Please see the technote below for information on changing from a basic disk to a dynamic disk configuration in a Microsoft Cluster.

How to move from a physical disk resource to a VERITAS Volume Manager (tm) disk group resource in a Microsoft cluster
http://www.symantec.com/docs/TECH31462

lightship's picture

Hello all,

 As Ricky mentioned before, I set up a windows 2008 r2 mscs environment, I use ordinary share volume to create the msdtc application, msdtc can normally switch to another server, however, if I use a vmdg disk to create the msdtc resources, msdtc cannot switch.

RickyLeung's picture

HI,mike

Everything above was done by my co-worker lightship.

one dayI installed and configure mscs with sfw cluster option,add vmdg,and created msdtc resource reside vmdg successfully!

So the resoult is MSCS supports vmdgs,and the MSDTC resource is available on VMDGs.

thanks

Ricky

SOLUTION