Cluster feature request
tstadler
Posts: 16
Hello,
Well this weekend we had some major changes on our 2 SQL clusters and now running on the alternate nodes. Here is what we have found, we installed SQL backup on these 2 clusters (Both active and inactive node) and made all of the configuration changes and activated the license based on what was the current active node. Backups worked great till now, we had to switch to the alternate nodes. All configuration and license was lost and backups started failing. Seems that the configuration and license is stored on each node in its registry. Problem when you can't switch nodes until an issue. Seems that for a cluster maybe the configuration shouldn't be stored on the node but in a Database hosted by the nodes. Litespeed stores it's procs and config in a database of its own, might be a nice feature in the future for Clustered SQL server setup. From now on we will be watchfull to copy the reg keys from node to node as needed for new setups.
I could be incorect in my findings, but this is what we observed.
Well this weekend we had some major changes on our 2 SQL clusters and now running on the alternate nodes. Here is what we have found, we installed SQL backup on these 2 clusters (Both active and inactive node) and made all of the configuration changes and activated the license based on what was the current active node. Backups worked great till now, we had to switch to the alternate nodes. All configuration and license was lost and backups started failing. Seems that the configuration and license is stored on each node in its registry. Problem when you can't switch nodes until an issue. Seems that for a cluster maybe the configuration shouldn't be stored on the node but in a Database hosted by the nodes. Litespeed stores it's procs and config in a database of its own, might be a nice feature in the future for Clustered SQL server setup. From now on we will be watchfull to copy the reg keys from node to node as needed for new setups.
I could be incorect in my findings, but this is what we observed.
Comments
SQL Backup is not currently cluster-aware, but we do have a published workaround for this, which I hope to get into the help file at some point.
If you add the SQL Backup Agent as a Generic Service resource in Cluster Administrator and replicate the registry keys listed in the topic referenced below, this should solve your problem in the future.
http://www.red-gate.com/messageboard/vi ... php?t=1880