Mission Critical: SQL Server 2008 Engine Post-Installation

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.

930-title.jpg

CTL10.05.001

Revision 2/15/2010 A

SQL Server 2OO8

Engine Post-Installation

CRITICAL TASK LIST PROGRAM

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.

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 here. You can also add additional information to this checklist based on your organization’s need.

CONTENT

Critical Task List 10.05.001 contains steps required to properly evaluate the post-installation steps 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:

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.

COMMENTS AND QUESTIONS

Comments and questions should be added at the end of the checklist.

Critical Task Lists Managers

Buck Woody “Real World DBA”

(MSFT U.S.)

Task

Notes

Confirmed

1.  Restarted SQL Server. (not required, but advised)

http://bit.ly/biK9yl

2.  Checked all service states for desired configuration, using SQL Server Configuration Manager.

http://bit.ly/9DRGeE

3.  Windows Update (if used) run for service-pack/hotfix detection.

http://bit.ly/40JY5f

4.  model System Database settings configured for desired global configuration.

http://bit.ly/diV7SZ

5.  Database Roles created in model System Database for desired global configuration.

http://bit.ly/8ZDO5

6.  Windows Accounts Granted Access as appropriate.

http://bit.ly/b4Ok3b

7.  SQL Server Instance and Database Accounts created as required.

http://bit.ly/b4Ok3b

8.  Accounts placed in appropriate Database and Server Roles.

http://bit.ly/acLjT3
http://bit.ly/8ZDO5

9.  All security set to be audited or documented for manual audit.

http://bit.ly/c62yzr

10.Tested connection from server and administration workstation using bcp, SQLCMD, PowerShell and SQL Server Management Studio (if installed).

http://bit.ly/9SWv8A

11.Databases Restored, where applicable.

http://bit.ly/d9jko9

12.Full Database Maintenance set up and run, evaluated for successful completion.

http://bit.ly/16jnXG

13.Monitoring installed and configured.

http://bit.ly/94juFZ

14.Evaluated Remote DAC. Configured where appropriate.

http://bit.ly/aaj7Hq

15.Encryption Keys set up and backed up to remote store.

http://bit.ly/9Pnwu0

16.System Documentation created.

http://bit.ly/1xtJk4

17.Performance baseline created.

http://bit.ly/9bRc06