Solved

SQL Server updates from Microsoft

Posted on 2009-06-29
18
222 Views
Last Modified: 2012-05-07
Is there any way I can get latest updates from Microsoft? like when ever they release a latest service pack or latest patch (If so where can I subscribe so that I can be notified thru my email )..

Pls help
0
Comment
Question by:shadyc
  • 9
  • 6
  • 3
18 Comments
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24740182
Why dont you use WSUS?
 
Products Supported by WSUS
0
 

Author Comment

by:shadyc
ID: 24740269
Is this is the only way?
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24740342
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:shadyc
ID: 24740616
It looking good but I need only for  SQL Server security updates and every thing related to SQL Server >pl direct me to that link or what ever so that I can subscribe to it.

Thanks
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24740884
If you want to apply Security patches alone, then you need to do it manually.
Using WSUS applies all sorts of patches into your machine.

For SQL Server, that's not recommended.
You can download the Service Packs Manually and apply it which is recommended.

If you do it automatically through WSUS and something fails in the middle then you will risk losing your data and server will be down.

Hence apply patches manually for SQL Server related things.
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24741944
"For SQL Server, that's not recommended."

Whhhaaaattt? not recommended by who?

 If that was the case it wouldnt be included in products and classifications. WSUS is definitely the way to go. Also you can configure WSUS to email you each time new updates are synchronized. So as soon as there is a SQL update ready to be approved you would get an email(along with all other updates).

As far as a link to only SQL updates, there is none. They would be included in the security bulletins along with all other updates.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24742156
>> Whhhaaaattt? not recommended by who?

If you have automatic updates configured through WSUS, then you might face the following issues.

1. Some Updates require a SQL Server Instance restart which is not recommended in a Production / Live Database.
2. While applying patches / updates it makes internal connection resets which are not recommended in a Production / Live Database.
3. If you apply Updates to go in this manner, then when installing Service Packs you will obtain errors stating that some of the features are already installed. ( Hope you might be aware that SQL Server Updates / Service Packs are cumulative.)

Hence normally in Production Environment, SQL Server Machines will be kept in machines where WSUS is not applicable and Even in many of the hotfixes for SQL Server, it is recommended to install them if they face some kind of problems. Otherwise its not recommended to install those updates.

We have faced several other problems like this in SQL Server because of Automatic Updates from WSUS.

Kindly Note that I am referring only to SQL Server related Updates/ Patches and not for Windows Server patches / Updates.

>>Also you can configure WSUS to email you each time new updates are synchronized. So as soon as there is a SQL update ready to be approved you would get an email(along with all other updates).

Agree with you on this aspect and WSUS works this way. But you need to analyze the updates whether it requires a instance restart or system restart and after that you need to apply it. In a production / Live database servers you cant allow WSUS to run on its own and that's what I referred earlier.

Hope I clarified you better.
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24742208
Hmmm.... still didnt provide documentation on this recommendation.

WSUS doesnt run on its own. You can configure how updates are approved. You can configure how restarts are handled. You can configure when updates are installed. You can configure for detect only and then install at your leisure. Sounds like you havent a full understanding of all the settings available with windows updates and WSUS.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24743225
Ok.. Some documentation for your reference.

http://support.microsoft.com/kb/942908/
http://support.microsoft.com/kb/943526/
http://support.microsoft.com/kb/945641/
http://support.microsoft.com/kb/945640/
http://support.microsoft.com/kb/942908/

In all the above SQL Server 2005 Updates / Hotfixes, you can see this paragraph "Hotfix Information"

Hotfix information
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

It suggests you to wait for the next Service Packs or Cumulative Packs so that the complete tested version of fix can be applied. That's why I recommended not to install these hotfixes through WSUS.

Applying Service Packs would be the ideal way and these kind of hotfixes should be applied only if required.

I am aware of WSUS functionality a little but not in depth but as per the information in all the hotfix links, Can you tell me whether I am correct or not.

Those hotfixes are intended for any machines that faces that problem and not for all. Applying to all machines might affect your existing thing too.

Hope My clarification sounds good with proofs on it.
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24744707
LOL, no it doesnt prove it one ioda. Those are all hotfixes. Hotfixes are for specific problems in certain cases. Hotfixes are not deployed thru either WSUS or Windows updates. They need to be requested, you dont get them unless you manually download them after getting the link via email. I understand your concerns, But we have been running many SQL databases in WSUS environment without a hitch.
0
 

Author Comment

by:shadyc
ID: 24745109
I just need to configure WSUS to my email so as soon as there is a SQL update ready to be approved I would get an email(along with all other updates). I can manually install them.
Can any one of you let me know how to subscribe. I dont really see that.


Thanks much!
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24745244
As below
wsusemail.bmp
0
 

Author Comment

by:shadyc
ID: 24745526
Can you send me the link pls..?or can you direct me from here..
http://technet.microsoft.com/en-us/wsus/default.aspx
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24745645
The picture above shows you exactly where to go to configure this. After doing so, every new update that is synchronized in wsus whether approved or not will send you an email.
 
The email will look similar as below

 

wsussampleemail.bmp
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24745654
I should have also asked, Do you have WSUS installed?
0
 

Author Comment

by:shadyc
ID: 24745754
No I dont have.
0
 

Author Comment

by:shadyc
ID: 24745854
Do I need to Install something?
0
 
LVL 47

Accepted Solution

by:
Donald Stewart earned 500 total points
ID: 24745885
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question