![\"930-title.jpg\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/imported\/930-title.jpg\")
<\/div>\nCTL10.01.001<\/p>\n
Revision 8\/14\/2009 A<\/p>\n
SQL Server 2OO8 <\/p>\n
Engine Pre-Installation<\/p>\n
\n
CRITICAL TASK LIST PROGRAM<\/b><\/p>\n
This document contains steps that will assist you in the completion of and installation of SQL Server 2008 RTM Enterprise Edition, non-clustered.<\/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 to http:\/\/www.simple-talk.com\/author\/buck-woody\/<\/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.01.001contains steps required to properly evaluate an installation 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: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 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>. <\/p>\n \n Critical Task Lists Managers <\/p>\n Buck Woody “Real World DBA”<\/p>\n (MSFT U.S.)<\/p>\n Brad McGeHee “The Professional DBA”<\/p>\n (RG U.S.) <\/p>\n \n
| \n Task<\/p>\n<\/td>\n | \n Notes<\/p>\n<\/td>\n | \n Confirmed<\/p>\n<\/td>\n<\/tr>\n |
| \n Server-level hardware installed and configured:<\/p>\n 1. CPU: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support, 1.4Ghz or higher<\/p>\n 2. Memory: 512 MB or higher<\/p>\n<\/td>\n | \n http:\/\/msdn.microsoft.com\/en-us\/library\/ms143506.aspx#EEx64<\/a> <\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Server-level Operating System installed and configured:<\/p>\n 1. Windows Server 2003 SP2 32\/64-bit Standard<\/p>\n 2. Windows Server 2003 SP2 32\/64-bit Datacenter<\/p>\n 3. Windows Server 2003 SP2 32\/64-bit Enterprise<\/p>\n 4. Windows Server 2008 32\/64-bit Standard<\/p>\n 5. Windows Server 2008 32\/64-bit Standard without Hyper-V<\/p>\n 6. Windows Server 2008 32\/64-bit Datacenter<\/p>\n 7. Windows Server 2008 32\/64-bit Datacenter without Hyper-V<\/p>\n 8. Windows Server 2008 32\/64-bit Enterprise<\/p>\n 9. Windows Server 2008 32\/64-bit Enterprise without Hyper-V<\/p>\n 10.Windows Server 2008 R2 32\/64-bit Web<\/p>\n 11.Windows Server 2008 R2 32\/64-bit Standard<\/p>\n 12.Windows Server 2008 R2 32\/64-bit Enterprise<\/p>\n 13.Windows Server 2008 R2 32\/64-bit Datacenter<\/p>\n<\/td>\n | \n http:\/\/msdn.microsoft.com\/en-us\/library\/ms143506.aspx#EEx64<\/a> <\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n One or more of the following network protocols installed and configured:<\/p>\n 1. Shared memory<\/p>\n 2. Named Pipes<\/p>\n 3. TCP\/IP<\/p>\n 4. VIA<\/p>\n<\/td>\n | \n http:\/\/msdn.microsoft.com\/en-us\/library\/bb500442.aspx<\/a> <\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Designed File Layouts – Separate physical drives for (at a minimum):<\/p>\n 1. Operating System Files<\/p>\n 2. Operating System Cache<\/p>\n 3. SQL Server Binary Files<\/p>\n 4. Data Files<\/p>\n 5. Log Files<\/p>\n 6. TempDB<\/p>\n 7. Indexes<\/p>\n 8. Backup Files<\/p>\n<\/td>\n | \n http:\/\/msdn.microsoft.com\/en-us\/library\/cc966412.aspx#EFAA<\/a> <\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Enhanced physical security <\/p>\n<\/td>\n | \n Secure physical access to the SQL Server hardware<\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Configured firewalls <\/p>\n<\/td>\n | \n http:\/\/msdn.microsoft.com\/en-us\/library\/cc646023.aspx<\/a> <\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Isolated services <\/p>\n<\/td>\n | \n http:\/\/msdn.microsoft.com\/en-us\/library\/ms143504.aspx<\/a> <\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Configured a secure file system <\/p>\n<\/td>\n | \n Use NTFS<\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Disabled NetBIOS and server message block<\/p>\n<\/td>\n | \n Not needed for SQL Server 2008<\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Ran the SQL Server Setup, system passes the System Configuration Checker (SCC)<\/p>\n<\/td>\n | \n http:\/\/msdn.microsoft.com\/en-us\/library\/ms143753.aspx<\/a> <\/p>\n<\/td>\n | <\/td>\n<\/tr>\n |
| \n Reviewed Installation Notifications if blocked<\/p>\n<\/td>\n | <\/td>\n | <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":" Even with a task you’re entirely familiar with, it is always great to have a checklist to make sure it is all done. No? Have you never forgotten your car-keys?…<\/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":[5140,5139,4170,5145,4150],"coauthors":[],"class_list":["post-845","post","type-post","status-publish","format-standard","hentry","category-database-administration-sql-server","tag-buck-woody","tag-critical-check-list","tag-database-administration","tag-engine-pre-installation","tag-sql"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/845","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=845"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/845\/revisions"}],"predecessor-version":[{"id":92267,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/845\/revisions\/92267"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=845"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} |