Forum Discussion

mokkan's avatar
mokkan
Level 6
10 years ago

VCS mount question

Hello, I have got the following request. and let me know is there a way I can setup.   I  need to setup a  SQL server  on Windows 2008 and data will be on RDM1. Also, there will be another R...
Basics
business continuity
Cluster Server
Windows Server (2003-2008)
  • Wally_Heim's avatar
    Wally_Heim
    10 years ago

    Hi Mokkan,

    Check out the FireDrill in the docs.  It should cover the ForFireDrill attribute in the VMDg and MountV resources. The other things that you will need to be concerned with is that the second service group will need a different IP and Lanman virtual server name so that it does not cause problems with the production SQL instance.

    The SQL server resource and GenericService resources should be OK since they should be using the virtual server name and can determine that SQL Server and SQL Agent services are running in a different virtual server context.  But you might want to be careful when you do your first test online of the second service group.

    Thank you,

    Wally

Wally_Heim's avatar
Wally_Heim
Level 6
10 years ago

Hi Mokkan,

I'm not sure that I understand the exact reason/need for this in a production environment.  But what you are asking sounds to me like you would need to reconfigure the service group to get the needed RDM disk/volume in the right location for SQL to use. 

I'm sure that you could script the changes needed but the exact changes needed would be depend on the disk/diskgroup configuration that you are using.  I would try to keep the change down to just modifying 1 or 2 Mount/MountV resources.  The simipler the change the less likely you are to mess it up.

Can you please go into more details on what you are trying to do by changing the drive/data that SQL is using?  Maybe there is something else that we can recommend that might work better for you situation.

Thank you,

Wally