Mission Critical: Engine Pre-Installation

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?

930-title.jpg

CTL10.01.001

Revision 8/14/2009 A

SQL Server 2OO8

Engine Pre-Installation

CRITICAL TASK LIST PROGRAM

This document contains steps that will assist you in the completion of and installation of SQL Server 2008 RTM Enterprise Edition, non-clustered.

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.

This CTL is not meant to be a replacement for the official documentation from the product manufacturer.  

CTL NUMBER

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.

HOW TO BE ASSURED OF HAVING LATEST DATA

Refer to http://www.simple-talk.com/author/buck-woody/. You can also add additional information to this checklist based on your organization’s need.

CONTENT

Critical Task List 10.01.001contains steps required to properly evaluate an installation for SQL Server 2OO8 on a new system.

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.

SUPPLEMENTS

Official Site Link:http://www.simple-talk.com/author/buck-woody/.

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.

COMMENTS AND QUESTIONS

Comments and questions should be directed through buck.woody@microsoft.com.

Critical Task Lists Managers

Buck Woody “Real World DBA”

(MSFT U.S.)

Brad McGeHee “The Professional DBA”

(RG U.S.)

Task

Notes

Confirmed

Server-level hardware installed and configured:

1.  CPU: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support, 1.4Ghz or higher

2.  Memory: 512 MB or higher

http://msdn.microsoft.com/en-us/library/ms143506.aspx#EEx64

Server-level Operating System installed and configured:

1.  Windows Server 2003 SP2 32/64-bit Standard

2.  Windows Server 2003 SP2 32/64-bit Datacenter

3.  Windows Server 2003 SP2 32/64-bit Enterprise

4.  Windows Server 2008 32/64-bit Standard

5.  Windows Server 2008 32/64-bit Standard without Hyper-V

6.  Windows Server 2008 32/64-bit Datacenter

7.  Windows Server 2008 32/64-bit Datacenter without Hyper-V

8.  Windows Server 2008 32/64-bit Enterprise

9.  Windows Server 2008 32/64-bit Enterprise without Hyper-V

10.Windows Server 2008 R2 32/64-bit Web

11.Windows Server 2008 R2 32/64-bit Standard

12.Windows Server 2008 R2 32/64-bit Enterprise

13.Windows Server 2008 R2 32/64-bit Datacenter

http://msdn.microsoft.com/en-us/library/ms143506.aspx#EEx64

One or more of the  following network protocols installed and configured:

1.  Shared memory

2.  Named Pipes

3.  TCP/IP

4.  VIA

http://msdn.microsoft.com/en-us/library/bb500442.aspx

Designed File Layouts – Separate physical drives for (at a minimum):

1.  Operating System Files

2.  Operating System Cache

3.  SQL Server Binary Files

4.  Data Files

5.  Log Files

6.  TempDB

7.  Indexes

8.  Backup Files

http://msdn.microsoft.com/en-us/library/cc966412.aspx#EFAA

Enhanced physical security

Secure physical access to the SQL Server hardware

Configured firewalls

http://msdn.microsoft.com/en-us/library/cc646023.aspx

Isolated services

http://msdn.microsoft.com/en-us/library/ms143504.aspx

Configured a secure file system

Use NTFS

Disabled NetBIOS and server message block

Not needed for SQL Server 2008

Ran the  SQL Server Setup, system passes the System Configuration Checker (SCC)

http://msdn.microsoft.com/en-us/library/ms143753.aspx

Reviewed Installation Notifications if blocked