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?
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]. You can see what fixes are included, how to determine your version, etc. Everything you need. :
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.