May 28, 2009 at 3:48 am
Hi,
I have 3 servers. In all the server I have sp4 installed, but the versions are different.
A server
Version = 8.00.2039
B server
version = 8.00.2055
C server
version = 8.00.2050
I have to synchronize all the server so that they have the same versions.
How am I supposed to do this. Please help..
Thanks,
Harsha B
May 28, 2009 at 4:08 am
Hi Harsha,
The differences will be down to cumilitve updates, .2039 is SP4.
As for .2055, the link http://support.microsoft.com/kb/959420 may be of assistance. If you want to sync up the version numbers you may have to apply the cumilitve updates (or hot fixes) to patch up to .2055, as im unsure if you can uninstall these updates.
hope this helps.
May 28, 2009 at 4:17 am
If the versions are diffrent will there be any problems in linking the servers?
If I do a cross query within the servers would I get any errors for any differences of hotfixes.
I have been asked to download all the hotfixes so that all the servers are in same version.
In the microsoft sites they are informing that the latest hotfixe has all the previous hotfixes and they give a list of it also. But if I try to find the hotfixes numbers with their article i am not able to find any of it.
So I am getting confused and my lot of time is going on researching which one to download and not .
May 28, 2009 at 4:27 am
I couldnt be 100% on whether there will be issues, it really depends if your using features updated in the hotfix.
If it were me, assuming you cant remove the updates or fixes (need to check if you can) then I would patch them all up to .2055 (or whatever your latest version is).
This will give you stable consistent versioning between your SQL instances.
The link (http://support.microsoft.com/kb/894905) tells you all the builds after SP4.
** notice that .2055 is not in here, this is because it is not a cumiliatve update, but is infact a hot fix (http://support.microsoft.com/kb/959420).
As a general rule you shouldnt apply cumilitve updates unless you are experiencing the specified problems, or at least that what Microsoft say. 😉
May 28, 2009 at 4:29 am
Thanks,
Thats was helpful...
May 28, 2009 at 4:30 am
No problem, happy to help.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply