Here is an example of a

Loic_Bouquet · ‎06-26-2013

Hello,

I'm working on a VCS cluster 6.0.1 under Windows 2008R2 with SQL2008R2. I cannot use the Wizard for SQL to configure Service Groups for SQL2008, because i have some issues with shared disk (call in progress to symantec support).

So, i try to configure manualy the SG, but i have an issue with the RegRep ressource. I cannot found real informations to configure this ressource. Actually my main.cf containt this :

    RegRep SQLInst1_SQL_RegRep (
       MountResName = SQLInst1_RegRep_Mount
       Keys = { "HKLM\\Software\\VERITAS\\" = "",
           "HKLM\\Software\\Microsoft\\Microsoft SQL Server" = "",
           "HKLM\\Software\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.SQLINST1" = "" }
       )

But, i think it's not sufficient, because i have many troubles with the failover of Service Groups.

Someone have a cluster configured with the wizard ? Who can share the complete definition of a service group for SQL2008 ? Thank you.

Note : When you use Wizard, you obtain this :

    RegRep SG_SQL03-RegRep-MSSQL (
       MountResName = SG_SQL03-Mount
       ReplicationDirectory = "\\RegRep\\SG_SQL03-RegRep-MSSQL"
       Keys = {
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.SQL03\\MSSQLServer" = "SaveRestoreFile:SG_SQL03-RegRep-MSSQL_MSSQLServer.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.SQL03\\PROVIDERS" = "SaveRestoreFile:SG_SQL03-RegRep-MSSQL_PROVIDERS.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.SQL03\\Replication" = "SaveRestoreFile:SG_SQL03-RegRep-MSSQL_Replication.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.SQL03\\SQLServerAgent" = "SaveRestoreFile:SG_SQL03-RegRep-MSSQL_SQLServerAgent.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.SQL03\\SQLServerSCP" = "SaveRestoreFile:SG_SQL03-RegRep-MSSQL_SQLServerSCP.reg" }
       ExcludeKeys = {
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.SQL03\\MSSQLServer\\CurrentVersion" }
       )

Karel_Bollen · ‎06-27-2013

Here is an example of a complete service group definitions generated with the SQL 2008 configuration wizard.

group ACC_APPSENSE (
   SystemList = { node1= 0, node2= 1 }
   AutoStartList = { node1, node2}
   )

   GenericService SQLServerAgent-ACC_APPSENSE (
       ServiceName = "SQLAgent$ACC_APPSENSE"
       UseVirtualName = 1
       LanmanResName = ACC_APPSENSE-Lanman
       )

   IP ACC_APPSENSE-IP (
       Address = "IP"
       SubNetMask = "255.255.255.0"
       MACAddress @node1= MAC1
       MACAddress @node2= MAC2
       )

   Lanman ACC_APPSENSE-Lanman (
       VirtualName = VIP
       IPResName = ACC_APPSENSE-IP
       DNSUpdateRequired = 1
       DNSCriticalForOnline = 1
       DNSOptions = { PurgeDuplicate }
       )

   MountV ACC_APPSENSE-MountV (
       MountPath = "S:"
       VolumeName = ACC_APPSENSE
       VMDGResName = ACC_APPSENSE-VMDg
       )

   MountV ACC_APPSENSE-MountV-1 (
       MountPath = "S:\\DATA"
       VolumeName = ACC_APPSENSE_DATA
       VMDGResName = ACC_APPSENSE-VMDg
       )

   MountV ACC_APPSENSE-MountV-2 (
       MountPath = "S:\\LOG"
       VolumeName = ACC_APPSENSE_LOG
       VMDGResName = ACC_APPSENSE-VMDg
       )

   MountV ACC_APPSENSE-MountV-3 (
       MountPath = "S:\\REG"
       VolumeName = ACC_APPSENSE_REG
       VMDGResName = ACC_APPSENSE-VMDg
       )

   NIC ACC_APPSENSE-NIC (
       MACAddress @node1= MAC1
       MACAddress @node2= MAC2
       )

   RegRep ACC_APPSENSE-RegRep-MSSQL (
       MountResName = ACC_APPSENSE-MountV-3
       ReplicationDirectory = "\\RegRep\\ACC_APPSENSE-RegRep-MSSQL"
       Keys = {
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.ACC_APPSENSE\\MSSQLServer" = "SaveRestoreFile:ACC_APPSENSE-RegRep-MSSQL_MSSQLServer.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.ACC_APPSENSE\\PROVIDERS" = "SaveRestoreFile:ACC_APPSENSE-RegRep-MSSQL_PROVIDERS.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.ACC_APPSENSE\\Replication" = "SaveRestoreFile:ACC_APPSENSE-RegRep-MSSQL_Replication.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.ACC_APPSENSE\\SQLServerAgent" = "SaveRestoreFile:ACC_APPSENSE-RegRep-MSSQL_SQLServerAgent.reg",
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.ACC_APPSENSE\\SQLServerSCP" = "SaveRestoreFile:ACC_APPSENSE-RegRep-MSSQL_SQLServerSCP.reg" }
       ExcludeKeys = {
           "HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10_50.ACC_APPSENSE\\MSSQLServer\\CurrentVersion" }
       )

   SQLServer2008 SQLServer2008-ACC_APPSENSE (
       Instance = ACC_APPSENSE
       LanmanResName = ACC_APPSENSE-Lanman
       SQLClusterAccount = "MSSQL$ACC_APPSENSE"
       )

   VMDg ACC_APPSENSE-VMDg (
       DiskGroupName = ACC_APPSENSE_DG
       DGGuid = 32783a08-a9f3-4f3b-bd20-168c94b1818b
       FastFailOver = 1
       )

   requires group PROD_APPSENSE offline local
   SQLServer2008-ACC_APPSENSE requires ACC_APPSENSE-MountV-1
   SQLServer2008-ACC_APPSENSE requires ACC_APPSENSE-MountV
   SQLServer2008-ACC_APPSENSE requires ACC_APPSENSE-RegRep-MSSQL
   SQLServer2008-ACC_APPSENSE requires ACC_APPSENSE-MountV-2
   SQLServer2008-ACC_APPSENSE requires ACC_APPSENSE-Lanman
   SQLServerAgent-ACC_APPSENSE requires SQLServer2008-ACC_APPSENSE
   ACC_APPSENSE-RegRep-MSSQL requires ACC_APPSENSE-MountV-3
   ACC_APPSENSE-MountV requires ACC_APPSENSE-VMDg
   ACC_APPSENSE-MountV-1 requires ACC_APPSENSE-MountV
   ACC_APPSENSE-MountV-2 requires ACC_APPSENSE-MountV
   ACC_APPSENSE-MountV-3 requires ACC_APPSENSE-MountV
   ACC_APPSENSE-IP requires ACC_APPSENSE-NIC
   ACC_APPSENSE-Lanman requires ACC_APPSENSE-IP

Karel

VOX

Issue with RegRep (Registry Replication Keys) ressource in VCS6.0 for SQL2008R2