{"id":807,"date":"2010-02-15T00:00:00","date_gmt":"2010-02-15T00:00:00","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/mission-critical-sql-server-2008-general-maintenance\/"},"modified":"2021-08-24T13:40:31","modified_gmt":"2021-08-24T13:40:31","slug":"mission-critical-sql-server-2008-general-maintenance","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/mission-critical-sql-server-2008-general-maintenance\/","title":{"rendered":"Mission Critical: SQL Server 2008 General Maintenance"},"content":{"rendered":"
\n
\"930-title.jpg\"<\/div>\n

CTL10.02.001<\/p>\n

Revision 09\/21\/2009 A<\/p>\n

SQL Server 2OO8 <\/p>\n

General Maintenance<\/p>\n

CRITICAL TASK LIST PROGRAM<\/b><\/p>\n

This document contains steps that will assist you in the day-to-day SQL Server 2008 RTM Enterprise Edition (non-clustered) operations. It defines the basics of standard maintenance and checks for a single Instance of SQL Server 2008, and should be used as a starting point.<\/p>\n

Review each item, placing a check in the “Confirmed” column when the task line is complete. Any line not marked “Confirmed” should stop the process until you have completed that line item.<\/p>\n

This CTL is not meant to be a replacement for the official documentation from the product manufacturer.  <\/p>\n

CTL NUMBER <\/b><\/p>\n

This Critical Task List is identified by a CTL number in the upper right-hand side of this document. You should use the latest CTL (identified by the date and an alpha-numeric code. <\/p>\n

HOW TO BE ASSURED OF HAVING LATEST DATA <\/b><\/p>\n

You can add additional information to this checklist based on your organization’s need.<\/p>\n

CONTENT <\/b><\/p>\n

Critical Task List 10.02.001<\/u><\/b>All content is the sole responsibility of the server owner; Microsoft Corporate provides no warranties implied or implicit in this document. This document is not a product of the Microsoft Corporation.  <\/p>\n

SUPPLEMENTS <\/b><\/p>\n

Official Site Link: http:\/\/www.simple-talk.com\/author\/buck-woody\/<\/a><\/p>\n

Whenever you receive a supplement affecting your checklist, write in the appropriate information. Printed replacement checklist pages will be made available to you as quickly as possible. A notation on the bottom inside corner of these pages will indicate that they reflect certain supplements. <\/p>\n

COMMENTS AND QUESTIONS <\/b><\/p>\n

Comments and questions should be directed through buck.woody@microsoft.com<\/a> Critical Task Lists Managers <\/b><\/p>\n

Buck Woody “Real World DBA”(MSFT U.S.).<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Frequency<\/b><\/p>\n<\/td>\n

\n

Task<\/b><\/p>\n<\/td>\n

\n

References<\/b><\/p>\n<\/td>\n

\n

Confirmed<\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Post-Installation<\/p>\n<\/td>\n

\n

Server and Database Settings Configured for Environment.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/H6z28<\/a> <\/p>\n

http:\/\/bit.ly\/1zwba<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Latest Service Packs Installed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/196VzN<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Database Mail Configured and Tested.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/8uEUn<\/a> <\/p>\n

http:\/\/bit.ly\/RR9xt<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Maintenance Wizard or other Automated Maintenance Implemented.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/16nhdL<\/a> <\/p>\n

http:\/\/bit.ly\/Uqoyh<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Baseline Performance Metrics Created and Archived.<\/p>\n<\/td>\n

\n

 http:\/\/bit.ly\/gVyI0<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Daily<\/p>\n<\/td>\n

\n

Backups Checked.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/2Ihz0f<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Windows Event Logs Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/1uGRe<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

SQL Server Error Logs Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/2Gk967<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Drive Space Checked.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/3mdRPj<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Jobs History Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/1gm4qM<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Backups Taken.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/sKgwj<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Indexes Updated.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/7wpHx<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Statistics Updated.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/3XGBKA<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Weekly<\/p>\n<\/td>\n

\n

Indexes Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/2DpOMR<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Long-Running Queries Reviewed<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/45RCm<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Data Archival Performed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/sKgwj<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Security Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/1asALb<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Service Packs and OS Security Bulletins Evaluated and Applied.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/q46L0<\/a> <\/p>\n

http:\/\/bit.ly\/pAGp2<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Monthly<\/p>\n<\/td>\n

\n

Security Tests Performed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/119slV<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

New Performance Baseline Recorded.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/gVyI0<\/a><\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Restore Tests Performed on Production Server to Backup Server.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/4vG8s<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Yearly<\/p>\n<\/td>\n

\n

Performance Reviews Completed from Baseline Comparisons.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/gVyI0<\/a><\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Growth Predictions Created from Baseline Metrics.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/vWSqS<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Instance Audit Performed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/12WPkh<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
<\/td>\n\n

Version Upgrade Plan Evaluated.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/e5MIy<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

There is nothing that beats a simple checklist for ensuring that things don’t get forgotten in the Database Maintenance process. Once again, Buck Woody imagines how the US military would have tackled DBA checklists for ‘mission-critical’ databases. …<\/p>\n","protected":false},"author":221875,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143527],"tags":[4168,4170,4150,4151],"coauthors":[],"class_list":["post-807","post","type-post","status-publish","format-standard","hentry","category-database-administration-sql-server","tag-database","tag-database-administration","tag-sql","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/221875"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=807"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/807\/revisions"}],"predecessor-version":[{"id":92271,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/807\/revisions\/92271"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=807"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}