Solved

What is the best way to keepup SQL Server with Updates?

Posted on 2010-11-17
4
196 Views
Last Modified: 2012-05-10

We all know with Windows, we can get automatic updates and we can install them whenever we want after reviewing them or we can schedule them to install automatically.

I wonder if there is a similar mechanizm that would be looking for SQL Server updates and help us keeping the SQL Server up to date with it's updates.

Any help or weblinks to derive a best practices / strategy would be greatly appreciated.

Thank You
0
Comment
Question by:Skerw
  • 2
4 Comments
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 34160185
I suppose you could automate that.  I'm not sure I'd recommend it, though.  You really need to review dbms updates before you apply them to determine what impact they might have on your system.
0
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 500 total points
ID: 34160719
What OS version do you use?  also what SQL server do you use?
MS server 2008, win vista and 7 can include updates for SQL server too...

Anyway

You can keep an eye on SQL updates (including service packs) at http://blogs.msdn.com/sqlreleaseservices.

And if you are using any kind off RSS reader you can subscribe to the feed at http://blogs.msdn.com/sqlreleaseservices/rss.xml 

Hope that helps :)
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 34160726
0
 

Author Comment

by:Skerw
ID: 34169197
Hi All,

Thank you for your responses.

Can we include the SQL Server updates into Windows Server 2008?

I am using Windows Server 2008 Standard and MS SQL Server 2008.

If yes, can you please let me know the steps?

Thank You
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

911 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

20 Experts available now in Live!

Get 1:1 Help Now