SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

September 2014 – SQL Server Monthly Maintenance Checklist

It’s time for a monthly reminder to review you SQL Server environment.  As with anything, just because it appears to be running well, doesn’t mean that there isn’t an unknown element causing issues today or in the near future.

A good way to review your environment is to have a checklist of what needs to be reviewed.  As an example of what you need to check, you can use my 10 Monthly Maintenance Tasks for SQL Server.  It covers most everything in your SQL Server environment that needs to be checked. If you see anything missing from that list, please leave a comment on this post.  And if there are good resources out there that should be included on the list – share those as well.

Checklist Updates

Since the last update, there have been a number of updates to SQL Server.  The most important in the list is the release of Service Pack 2 for SQL Server 2012.  The whole list of changes to the list are:

SOMETHING MISSING?

Is there something missing in this checklist or with the pages that has been overlooked?  Any cool links that would aid in the review of your SQL Server environments?  If so, leave a comment below and I’ll take a look.

Comments

Leave a comment on the original post [www.jasonstrate.com, opens in a new window]

Loading comments...