Solved

SQL Server updates from Microsoft

Posted on 2009-06-29
18
193 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Select on LT running Totals 6 63
Where clause in stored procedure 8 50
CREATE DATABASE ENCRYPTION KEY 1 56
Selection from table2 where criteria for table1 10 31
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

930 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

14 Experts available now in Live!

Get 1:1 Help Now