Listing registry keys for all resources in a 2003 Cluster


This might be useful for documentation and also for migration plans related to an SQL Cluster.

All the Registry keys that are mentioned in this post are located under HKEY_LOCAL_MACHINE\SOFTWARE

The output of “cluster res /checkpoints”

"No resource name specified.
Listing registry checkpoints for all resources...
Resource             Registry Checkpoint
-------------------- --------------------------------------------------------
PBX-(<NODE-A>)       None
PBX-(<NODE-B>)       None
Cluster IP Address   None
Cluster Name         None
Disk Q:              None
MSDTC                None
Disk Y:              None
Disk X:              None
SQL Network Name (<Instance name>) None
SQL IP Front-End (<Instance name>) None
SQL IP Backup (<Instance name>)    None
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.2\CPE'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.2\Replication'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.2\SQLserverAgent'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.2\Cluster'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLSERVER'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.2\PROVIDERS'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.2\SQLServerSCP'
DISK H:              None
SQL Server Agent (<Instance name>) None
SQL Server Fulltext (<Instance name>)
        'Software\Microsoft\Microsoft SQL Server\MSSQL.2\MSSearch\GlobalAdminblob'
Disk R:              None
Disk N:              None
SQL Network Name (<Instance name>) None
SQL IP Front-End (<Instance name>) None
SQL IP Backup (<Instance name>) None
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.1\CPE'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.1\Replication'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.1\SQLserverAgent'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.1\Cluster'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLSERVER'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.1\PROVIDERS'
SQL Server (<Instance name>) 'Software\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerSCP'
DISK G:              None
Disk M:              None
Disk K:\             None
SQL Server Agent (<Instance name>) None
SQL Server Fulltext (<Instance name>)
         'Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\GlobalAdminblob'"

Hope that this information can be useful

Advertisements

About rodvars
Been working in IT Services/Consulting for the past 15 years. My main areas of work are planning, development, managing and administration System infrastructures focusing on optimizing user processes, enforcing business security, performance enhancements, high availabilty and infrastucture scalability.

4 Responses to Listing registry keys for all resources in a 2003 Cluster

  1. Hi, I just stopped by to visit your blog and thought I’d say thank you.

  2. Idell Rafey says:

    I must show appreciation to the writer just for rescuing me from this particular difficulty. Because of browsing throughout the the net and finding notions which were not pleasant, I assumed my entire life was well over. Being alive minus the answers to the issues you have resolved through your entire posting is a serious case, as well as the ones that could have in a negative way damaged my career if I hadn’t noticed the blog. Your natural talent and kindness in controlling everything was precious. I am not sure what I would’ve done if I hadn’t come across such a stuff like this. I can also now look forward to my future. Thanks so much for this expert and result oriented guide. I will not be reluctant to endorse your blog to anybody who ought to have care on this area.

  3. racetam says:

    Very interesting information!Perfect just what I was looking for!

  4. Very interesting info!Perfect just what I was looking for!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: