--Set backup loaction in the registry
exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\\Microsoft\\MSSQLServer\\MSSQLServer', N'BackupDirectory', 'REG_SZ', 'G:\\MSSQL.1\\MSSG\\Backup'
--Set data loaction in the registry
exec master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\\Microsoft\\MSSQLServer\\MSSQLServer', N'DefaultData', 'REG_SZ', 'E:\\MSSQL.1\\MSSG\\Data'
--Set log loaction in the registry
exec master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\\Microsoft\\MSSQLServer\\MSSQLServer', N'DefaultLog', 'REG_SZ', 'F:\\MSSQL.1\\MSSG\\Data'
Now last week the OS on the servers in the cluster were patched and after the reboot all of the default locations where changed back to: Data = H:\\MSSQL.1\\MSSQL\\Data LOG = H:\\MSSQL.1\\MSSQL\\Data Backup = H:\\MSSQL.1\\MSSQL\\Backup These servers have been patch several times throughout the years and this is the first time it has ever happened. We have seen it switch Server Authentication a few times from Mixed to Windows.