question

askmlx121 avatar image
askmlx121 asked

how will i know Recently updated service pack & Security patch in SQL SERVER?

Hi, We are using Windows Server 2003, SQL SERVER 2005 So May i know which way to know Recently updated service pack & Security patch in SQL SERVER? Where can i get this latest service pack & Security patch for SQL Server? what is the use of it?
sql-server-2005securityservice-pack
10 |1200

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

Grant Fritchey avatar image
Grant Fritchey answered
The primary reason to keep up with service packs and cumulative updates is security. The changing threats out there that Microsoft regularly seals up is the driver behind keeping up. Then, there are bugs and enhancements that come out that you may need. The source for this information is the same as the primary source for all information, Microsoft. They maintain a giant web site, Microsoft Developers Network (MSDN), that has all the documentation, downloads, service packes, hot fixes, cumulative updates, etc. for all their server software. Here's the link for [SQL Server 2005][1]. You can see what fixes are included, how to determine your version, etc. Everything you need. [1]: http://support.microsoft.com/kb/913089
10 |1200

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

ThomasRushton avatar image
ThomasRushton answered
Don't forget to check the build updates issued after the service pack - http://support.microsoft.com/kb/2485757
1 comment
10 |1200

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

askmlx121 avatar image askmlx121 commented ·
Thankx Grant Fritchey and Thomas Rushton. It has given the lot of knowledge about the patches and packs..................
0 Likes 0 ·
Tim avatar image
Tim answered
Also please make sure that backing up Master database is part of your daily backups or at least back it up after every single service pack, hot fix, cumulative update, etc. If and when you have to restore Master you will have to be at the same build level in order to restore Master so it is also nice to keep a local downloaded copy of those SP's and KB patches that are being installed.
10 |1200

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

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.