x

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

narendba gravatar image

narendba
570 26 37 45

(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

Tim gravatar image

Tim
36.4k 35 41 139

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.-

more ▼

answered Oct 01, 2012 at 07:29 PM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

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

K. Brian Kelley gravatar image

K. Brian Kelley
933 2

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1944

asked: Oct 01, 2012 at 04:45 PM

Seen: 491 times

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