question

Sharma avatar image
Sharma asked

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?
service-pack
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
@sqlchamp, you accepted the answer on this, and now have un-accepted it. Is there something wrong?
0 Likes 0 ·
Sharma avatar image Sharma commented ·
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.
0 Likes 0 ·

1 Answer

·
Kev Riley avatar image
Kev Riley answered
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.
11 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sharma avatar image Sharma commented ·
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.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
That seems to be the only source. Why do you not want to download this one, it won't replace your existing installation.
0 Likes 0 ·
Sharma avatar image Sharma commented ·
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.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
It is only 35MB (assuming 32-bit only), or 54MB if you need 64-bit WOW
0 Likes 0 ·
Sharma avatar image Sharma commented ·
Should I stop SQL Service before update the service pack?
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.