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

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

Created: 25 Jun 2013 • Updated: 26 Jun 2013 | 1 comment

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" }
        )
 

Operating Systems:

Comments 1 CommentJump to latest comment

Karel Bollen's picture

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