Hello Liam and CGuinn
We're investigating this also.
I learned from our DBA there is something called alias. Unfortunately, I do not have the exact paper with me (CET is 21:35) but will have tomorrow morning. Instead of having to adjust the registry and databases, you add an alias to each vault server, which points to the new SQL server. Kind of like dns alias.
EV now goes to SQL1
New SQL2008 machine will be called SQL2
Create Alias on EV server: SQL1 = SQL2
Move db's (using (as Liam said) backup/restore just in case.
Check EV after starting.
I ran this by Symantec Support, and according to them this indeed should work. Unfortunately, I have not yet been able to test, as our test-environment did not allow for 2 different sql versions. I'll try on VMWare somwhere in the next few weeks. The upgrade plan will be done in august/sept, when SP2 for 8 is out. (hopefully, fingers crossed and all that.
Gertjan
ps. Will post tomorrow when @ work the document
Gertjan,
I have heard of this, I have never tried it but the concept is sound. The reason why i would not use this is that it adds more support overhead. The more areas you need to support the more chances of something breaking and the harder it is to troubleshoot. That why i recommended to CQuinn to keep the server names the same when the SQL servers are switched that way it is seemless changeover