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

Question

question

askmlx121 asked Mar 21, '13

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-2005 security service-pack

10 |1200

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

Answer 1 · 2013-03-21T12:26:29Z

Grant Fritchey answered Mar 21, '13

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

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

Answer 2 · 2013-03-21T12:34:39Z

ThomasRushton answered Mar 21, '13

Don't forget to check the build updates issued after the service pack - http://support.microsoft.com/kb/2485757

1

10 |1200

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

askmlx121 commented · Mar 21, 2013 at 01:11 PM

Thankx Grant Fritchey and Thomas Rushton. It has given the lot of knowledge about the patches and packs..................

0 ·

Answer 3 · 2013-03-21T16:25:13Z

Tim answered Mar 21, '13

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

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

question