Click here to monitor SSC
Av rating:
Total votes: 6
Total comments: 8


Buck Woody
Mission Critical: SQL Server 2008 Engine Post-Installation
03 March 2010


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

 

 



This article has been viewed 5215 times.
Buck Woody

Author profile: Buck Woody

Buck Woody has been working with Information Technology since 1981. He has worked for the U.S. Air Force, at an IBM reseller as technical support, and for NASA as well as U.S. Space Command as an IT contractor. He has worked in most all IT positions from computer repair technician to system and database administrator, and from network technician to IT Manager and with multiple platforms as a Data Professional. He has been a DBA and Database Developer on Oracle systems running on a VAX to SQL Server and DB2 installations. He has been a Simple-Talk DBA of the Day

Search for other articles by Buck Woody

Rate this article:   Avg rating: from a total of 6 votes.


Poor

OK

Good

Great

Must read
 
Have Your Say
Do you have an opinion on this article? Then add your comment below:
You must be logged in to post to this forum

Click here to log in.


Subject: interesting
Posted by: Anonymous (not signed in)
Posted on: Friday, March 05, 2010 at 7:21 AM
Message: Hi my name is jhon and i found your article very interesting.


Subject: Article title has letter O rather than number 0 in the SQL version number.
Posted by: Anonymous (not signed in)
Posted on: Monday, March 08, 2010 at 4:39 AM
Message: The title of this article has two letter O's rather than number 0 (zero) in the SQL version.

how about a proofreading checklist before article publication?

Subject: A clever plot? Or perhaps a puzzle? What about that name change!
Posted by: Buck Woody (not signed in)
Posted on: Monday, March 08, 2010 at 4:21 PM
Message: Mr. Anonymous: Ah - perhaps it's all part of some clever puzzle!

Actually, it's an artifact of the font. Wanting this checklist to look like an older typewriter, the font authors substituted (as did the original typewriter) the O's for 0's.

But good catch! I have instructed Microsoft to change the name from "SQL Server two-thousand eight" to SQL Server Two Oh Oh Eight". I am awaiting their response, which for some unknown reason is delayed in coming. I'll keep you posted.

2OO8 2008 2oo8 TwoOhOhEight TwoZeroZeroEight. Hmm. Hard to say which is better.

Subject: How about?
Posted by: Robert L Davis (not signed in)
Posted on: Monday, March 08, 2010 at 4:31 PM
Message: How about SQL Server Two Double Naught Eight?

Subject: SQL Version
Posted by: Rodney (view profile)
Posted on: Tuesday, March 09, 2010 at 7:11 AM
Message: SQL Server 12G ?
Nope

Subject: installation verification
Posted by: Anonymous (not signed in)
Posted on: Wednesday, March 10, 2010 at 1:14 AM
Message: Thank you for interested information, this remind us when doing installation for IBM product at MVS machine, where post installation are part of installation documentation and verification.

Subject: installation verification
Posted by: Anonymous (not signed in)
Posted on: Wednesday, March 10, 2010 at 1:54 AM
Message: Thank you for interested information, this remind us when doing installation for IBM product at MVS machine, where post installation are part of installation documentation and verification.

Subject: SQL Version
Posted by: gordonp (view profile)
Posted on: Monday, March 15, 2010 at 9:49 AM
Message: I suggest we drop the 2 and go with double-oh-eight. Gives it that secret agent feel.

 










Phil Factor
Automated Script-generation with Powershell and SMO
 In the first of a series of articles on automating the process of building, modifying and copying SQL Server... Read more...



 View the blog
Using SQL Test Database Unit Testing with TeamCity Continuous Integration
 With database applications, the process of test and integration can be frustratingly slow because so... Read more...

SQL Source Control: The Development Story
 Often, there is a huge difference between software being easy to use, and easy to develop. When your... Read more...

How to Import Data from HTML pages
 It turns out that there are plenty of ways to get data into SQL Server from websites, whether the data... Read more...

SQL Scripts Manager: An Appreciation
 SQL Scripts Manager is Simple-Talk's present to its readers. William Brewer was an enthusiastic... Read more...

Hosted Team Foundation Server 2010 Review
 Team Foundation Server (TFS) has expanded its remit to support the whole software development process,... Read more...

Beginning SQL Server 2005 Reporting Services Part 1
 Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes
 Database design and implementation is the cornerstone of any data centric project (read 99.9% of... Read more...

Reading and Writing Files in SQL Server using T-SQL
 SQL Server provides several "standard" techniques by which to read and write to files but, just... Read more...

Beginning SQL Server 2005 Reporting Services Part 2
 Continuing his in-depth tour of SQL Server 2005 Reporting Services, Steve Joubert demonstrates the most... Read more...

Creating CSV Files Using BCP and Stored Procedures
 Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing... Read more...

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk