If the servers will changes to RTM(sql server 2005) to SP2, What are the advantages will get?

We have a non-prod and prod servers are in RTM now...

We are planning to move them to SP2, So what are the advantages will get?

more ▼

asked Oct 01, 2012 at 04:45 PM in Default

avatar image

658 35 50 58

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Support of database mirroring, improvements to the query optimizer just to name two.

more ▼

answered Oct 01, 2012 at 04:53 PM

avatar image

40.9k 39 94 168

If the server is running under RTM we are not able to set mirroring right?

Oct 02, 2012 at 09:40 AM narendba
(comments are locked)
10|1200 characters needed characters left

A wide range of bug fixes spring immediately to mind.-

[1]: http://support.microsoft.com/lifecycle/?LN=en-us&x=11&y=8&p1=2855

more ▼

answered Oct 01, 2012 at 07:29 PM

avatar image

26.2k 18 37 48

Not with SP2 you don't - mainstream support only applies to 2005 SP4

Oct 01, 2012 at 07:58 PM ThomasRushton ♦♦

If we upgrade the service pack... Is it a minor revision change? What is the benefit? Please clarify.

Oct 01, 2012 at 09:00 PM narendba

Can Anyone explain, if we are moving RTM to SP1 or SP2 or SP3 or SP4... What are the benfits we will get for each and every service pack?

Oct 01, 2012 at 09:12 PM narendba

@ThomasRushton - totally right, removed that part - misread the linked article. I took "not applicable" to mean that it didn't/hadn't ended. Should have looked a little to the right on the table.

Oct 02, 2012 at 06:19 AM WilliamD

@narendba - please go to the MSDN articles for each SP to see what is included (if at all listed). Basically, you will get a whole lot of bug-fixes that have been thoroughly tested. It is not common for there to be additional features as SPs are basically for free. It is normally recommended to keep up to date with SPs (after testing they have no ill effect on your system).

Oct 02, 2012 at 06:21 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

You really want to go all the way up to SP4 in order to get back into mainstream support.

Yes, with SP2 you will get bug fixes... any that were included in SP1 and SP2, since all bug fixes are cumulative. You will also get database mirroring, as that was turned on in SP1. I believe you also get the ability to run reports from SSMS (if you're running the SP2 where the SQL Server client tools are installed).

However, there are a whole slew of bug fixes in SP3 and SP4, plus that puts you in good stead in case there is a security issue. Microsoft won't release a patch for SP2. Not a good situation to be in.

more ▼

answered Oct 03, 2012 at 12:50 PM

avatar image

K. Brian Kelley
1k 1 4 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 01, 2012 at 04:45 PM

Seen: 599 times

Last Updated: Oct 03, 2012 at 12:50 PM

Copyright 2018 Redgate Software. Privacy Policy