Solved

SQL Server updates from Microsoft

Posted on 2009-06-29
18
183 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
 

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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now