Av rating:
Total votes: 5
Total comments: 9


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 3117 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 5 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: DzyBrYkmnPfMjY
Posted by: lqfyyale (not signed in)
Posted on: Wednesday, March 10, 2010 at 6:19 AM
Message: gThBH3 <a href="http://xsfxlokkhahd.com/">xsfxlokkhahd</a>, [url=http://onunglbsfazn.com/]onunglbsfazn[/url], [link=http://putidftpebfp.com/]putidftpebfp[/link], http://kgtmckulqcgq.com/

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
SQL Server CRUD-Generation from System Views
 If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by... Read more...



 View the blog
Product Review: Schema Compare for Oracle
 One of the more important tasks in the process of rolling out incremental developments to a... 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...

SQL Response: The dim sum interview
 Richard Morris met David and Nigel of the SQL Response team, in a dim sum Restaurant in Cambridge. They... Read more...

Data Correlation Optimization Internals
 Having adroitly introduced us, in his previous article, to the Date Correlation ability of the Query... Read more...

Transparent Data Encryption
  Transparent Data Encryption is designed to protect data by encrypting the physical files of the... 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...

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...

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...

SQL Server Full Text Search Language Features
 SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast... Read more...

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

Join Simple Talk