|
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?
(comments are locked)
|
|
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. 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 '11 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 '11 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 '11 at 04:39 AM
Amardeep
It is only 35MB (assuming 32-bit only), or 54MB if you need 64-bit WOW
Oct 27 '11 at 04:49 AM
Kev Riley ♦♦
Should I stop SQL Service before update the service pack?
Oct 27 '11 at 04:53 AM
Amardeep
(comments are locked)
|
@sqlchamp, you accepted the answer on this, and now have un-accepted it. Is there something wrong?
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.