Comments and answers for "Default Data, log and backup location changed after reboot"https://ask.sqlservercentral.com/questions/48768/default-data-log-and-backup-location-changed-after.html
The latest comments and answers for the question "Default Data, log and backup location changed after reboot"Comment by Blackhawk-17https://ask.sqlservercentral.com/comments/49056/view.html
Any updates...?Fri, 18 Nov 2011 07:44:22 GMTBlackhawk-17Answer by Blackhawk-17https://ask.sqlservercentral.com/answers/48783/view.html
Writing to the registry probably only did so on the node that was active at the time.
On a failover it would be using the registry from a different node.
Make sure that if you do registry work that all nodes are kept in synch.Sat, 12 Nov 2011 21:10:36 GMTBlackhawk-17Answer by ThomasRushtonhttps://ask.sqlservercentral.com/answers/48772/view.html
It sounds to me as though one of the servers in the cluster hasn't been set up the same way as the others. It might be worth checking the registry settings for all machines in the cluster.
As I wrote elsewhere (<http://thelonedba.wordpress.com/2010/11/09/on-master4idr-ckp-maintenance-plans-default-backup-directory-and-sql-server-configuration/>),
>In order to find (and change) this setting, we need to dive into the registry, to (deep breath):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
>In there, you’ll find a value for each instance defined on your server. Look at the Data value, and then navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<<instancename>>\MSSQLServer
Check that the appropriate directories are set up correctly across all cluster servers and their instances of SQL Server within the clusters.Fri, 11 Nov 2011 11:28:59 GMTThomasRushton