{"id":823,"date":"2010-03-03T00:00:00","date_gmt":"2010-03-03T00:00:00","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/mission-critical-sql-server-2008-engine-post-installation\/"},"modified":"2021-08-24T13:40:30","modified_gmt":"2021-08-24T13:40:30","slug":"mission-critical-sql-server-2008-engine-post-installation","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/mission-critical-sql-server-2008-engine-post-installation\/","title":{"rendered":"Mission Critical: SQL Server 2008 Engine Post-Installation"},"content":{"rendered":"<\/p>\n
\n
\"930-title.jpg\"<\/div>\n

CTL10.05.001<\/p>\n

Revision 2\/15\/2010 A<\/p>\n

SQL Server 2OO8 <\/p>\n

Engine Post-Installation<\/p>\n

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

This document contains steps that will assist you in the completion of and review of a installation of a non-clustered SQL Server 2008 RTM Enterprise Edition software Instance.<\/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

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

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

Critical Task List 10.05.001 contains steps required to properly evaluate the post-installation steps for SQL Server 2OO8 on a new system. <\/p>\n

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: <\/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 added at the end of the checklist. <\/p>\n

Critical Task Lists Managers <\/p>\n

Buck Woody “Real World DBA”<\/p>\n

(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

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

\n

Notes<\/p>\n<\/td>\n

\n

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

\n

1.  Restarted SQL Server. (not required, but advised)<\/p>\n<\/td>\n

\n

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

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

2.  Checked all service states for desired configuration, using SQL Server Configuration Manager.<\/p>\n<\/td>\n

\n

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

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

3.  Windows Update (if used) run for service-pack\/hotfix detection.<\/p>\n<\/td>\n

\n

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

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

4.  model<\/i> System Database settings configured for desired global configuration.<\/p>\n<\/td>\n

\n

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

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

5.  Database Roles created in model<\/i> System Database for desired global configuration.<\/p>\n<\/td>\n

\n

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

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

6.  Windows Accounts Granted Access as appropriate.<\/p>\n<\/td>\n

\n

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

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

7.  SQL Server Instance and Database Accounts created as required.<\/p>\n<\/td>\n

\n

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

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

8.  Accounts placed in appropriate Database and Server Roles.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/acLjT3<\/a>
http:\/\/bit.ly\/8ZDO5<\/a> <\/p>\n<\/td>\n

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

9.  All security set to be audited or documented for manual audit.<\/p>\n<\/td>\n

\n

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

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

10.Tested connection from server and administration workstation using bcp, SQLCMD, PowerShell and SQL Server Management Studio (if installed).<\/p>\n<\/td>\n

\n

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

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

11.Databases Restored, where applicable.<\/p>\n<\/td>\n

\n

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

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

12.Full Database Maintenance set up and run, evaluated for successful completion.<\/p>\n<\/td>\n

\n

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

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

13.Monitoring installed and configured.<\/p>\n<\/td>\n

\n

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

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

14.Evaluated Remote DAC. Configured where appropriate.<\/p>\n<\/td>\n

\n

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

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

15.Encryption Keys set up and backed up to remote store.<\/p>\n<\/td>\n

\n

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

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

16.System Documentation created.<\/p>\n<\/td>\n

\n

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

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

17.Performance baseline created.<\/p>\n<\/td>\n

\n

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

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

Even an experienced DBA finds it safer to double-check that all the tasks have been done, and in the right order. Buck Woody continues his series with another handy checklist, army-style.…<\/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":[4170,4150,4151],"coauthors":[],"class_list":["post-823","post","type-post","status-publish","format-standard","hentry","category-database-administration-sql-server","tag-database-administration","tag-sql","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/823","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=823"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/823\/revisions"}],"predecessor-version":[{"id":92270,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/823\/revisions\/92270"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=823"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}