Solved

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

Posted on 2010-11-17
4
218 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:Scott Pletcher
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

685 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