Proper steps install missing service packs to a SQL 2008 server

We are looking for the proper way to upgrade a sql2008 server instance to have the same version number sp number as another.  How can we go about this?
rayluvsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Adam BrownSr Solutions ArchitectCommented:
The service pack/roll up installers should give you the option of which instance to upgrade. Just go through the upgrade installer's controls and look for the page that asks for which instance to upgrade.
rayluvsAuthor Commented:
What do you mean by "The service pack/roll up installers should give you the option ".  Usually we download the latest service pack and install it.

For the sake of this question, we have a production server running sql2008 version 10.1600.22.  We have a test-environment server with sql2008 version 10.0.6000.  We need to run certain apps that must run in sql2008 version 10.1600.22

What sql service pack I have to download (where do I find it) to update the test-environment sql2008 server form 10.0.6000  to 10.1600.22?
Vitor MontalvãoMSSQL Senior EngineerCommented:
For SQL Server 2008 (not R2) download the last service that's SP4. Install it first in your DEV machines and let it there to be tested during 1 or 2 days before you install it in Production.
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

rayluvsAuthor Commented:
How do I know the production server is  or is R2?

The provided link says will upgrade to version 10.0.6000.29 (see pix below)

sql2008 upg versin to
We need the test-environment server with sql2008 (which is 10.0.6000), upgrade to be same version as production server, 10.1600.22.
Vitor MontalvãoMSSQL Senior EngineerCommented:
10.0.xxxx is SQL Server 2008.
10.5.xxxx is SQL Server 2008R2.

So you're working with a SQL Server 2008 version.
rayluvsAuthor Commented:
Understood; based your comment, that means that currently our production server is SQL2008 non-R2 (since its version is 10.1600.22 which not is not in format “10.5.xxxx”).

Your previous link says SP4 will upgrade our test-server to version 10.0.6000.29.  We need to update to 10.1600.22 - that means maybe there is a previous service pack or hotfix that will take the version to 10.1600.22 (a bit prior 10.1600.29)
rayluvsAuthor Commented:
(For some reason I cannot edit my previous entry via my mobile, so here is a new entry).

In other word, what service pack or hotfix we need in order to upgrade our test-server from 10.0.6000 to 10.1600.22?
Vitor MontalvãoMSSQL Senior EngineerCommented:
SQL Server 10.0.1600 is the same as 10.1.1600.22 as that's the SQL Server 2008 RTM version so with not even an hotfix.
Good news is that you can apply directly the SP4 since the updates are cumulative. After you install it, the new version should be 10.0.6000 or 10.1.6000 (it's the same).
I also recommend you to apply the last hotfix after SP4, since it's a security update. Download and apply it after you apply SP4. With that your SQL Server 2008 version will become 10.0.6556.
rayluvsAuthor Commented:
Thanx for the info.

For this test sever I need to upgrade only it 10.1600.22, no more.  Your steps will upgrade it to 10.0.6556.

Your recommendations are optimal for full upgrade to the latest service pack & hot fix, no doubt about,  but for our purpose here we need to have he test server only to 10.1600.22.

From I gather, there is no way to go about it?
Vitor MontalvãoMSSQL Senior EngineerCommented:
for our purpose here we need to have he test server only to 10.1600.22.
That's the RTM version, meaning is the below version that you can have for SQL Server 2008 as it's the version that it was released meaning that you should do nothing. Mind that Microsoft doesn't support this version anymore.
rayluvsAuthor Commented:
Hi,

Excuse the delay.

What  we are trying to accomplish is updating a server to be the same SQL version of another.  We are not looking for updating to latest SQL version (Service-Pack, Hotfix, etc.),  We  want to have both sql server with the same SQL version.

In detail:
We have the main SQL server (say SQL1) running sql2008 version 10.0.6241.0.
We also have a test SQL server (say SQL2) with sql2008 version 10.0.1600.22.

We want to have SQL2 to have the same version of SQL1 (in other words, update SQL2 version of 10.0.1600.22 to 10.0.6241.0).


Can we have SQL2 to have SQL version 10.0.6241.0? if yes, how?
(hope I have transmitted what we are trying to do)
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok, understood.
The 10.0.6241.0 is this hotfix that must be applied after you apply the SP4.
With that said, download and apply the SQL Server 2008 SP4 and then download and apply the above hotfix.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rayluvsAuthor Commented:
Thanx!
rayluvsAuthor Commented:
Thanx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.