x

What is the best practice for decide to upgrade MS SQL Database service Pack.

Hi,

I think for upgrade MS SQL Service pack we can check the service pack fix and decide for upgrade, Is this correct approach or always we should keep product latest service pack.

My concern is only here to make mine database service more secure and best performance.

Is there any disadvantage of keep latest service pack?

Is any financial investment involving in upgrade the latest service pack that we have to pay Microsoft for upgrade product service pack?

more ▼

asked Oct 26, 2011 at 10:52 PM in Default

Amardeep gravatar image

Amardeep
1.3k 87 88 89

@sqlchamp, you accepted the answer on this, and now have un-accepted it. Is there something wrong?
Oct 27, 2011 at 03:18 AM Kev Riley ♦♦
Nothing is wrong in answer, you are right but I had one more query related to this that's why I open it again. Sorry about that.
Oct 27, 2011 at 04:40 AM Amardeep
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

It is not unknown for service packs to introduce new bugs, so whilst it is a good approach to keep up with the latest service packs for security and performance and stability, you should always test the service pack on a dev or test version of your database/application/code, just like you would with ANY change.

To answer your financial question - no, as long as you have paid for the licence for the product initially, then service pack updates are free.
more ▼

answered Oct 27, 2011 at 12:51 AM

Kev Riley gravatar image

Kev Riley ♦♦
53k 47 49 76

How to get only service pack for MS SQL 2005 Express Edition- I know link - http://www.microsoft.com/download/en/details.aspx?id=184 but this contain complete software product i want only service pack setup.
Oct 27, 2011 at 02:46 AM Amardeep
That seems to be the only source. Why do you not want to download this one, it won't replace your existing installation.
Oct 27, 2011 at 03:09 AM Kev Riley ♦♦
It contain complete SQL 2005 Express Edition Database Service but I want only Service pack patch that will be essay for me to transfer on Internet to different machines.
Oct 27, 2011 at 04:39 AM Amardeep
It is only 35MB (assuming 32-bit only), or 54MB if you need 64-bit WOW
Oct 27, 2011 at 04:49 AM Kev Riley ♦♦
Should I stop SQL Service before update the service pack?
Oct 27, 2011 at 04:53 AM Amardeep
(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:

x28

asked: Oct 26, 2011 at 10:52 PM

Seen: 1317 times

Last Updated: Jul 22 at 11:32 AM