solving sql server problems for millions of dbas and developers since 2006

Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

SQL Product Highlight

Idera - SQL safe backup

Idera's SQL safe provides a high-performance backup and recovery solution for Microsoft SQL Server. SQL safe saves money by reducing database backup time by up to 50% over native backups and reducing backup disk space requirements by up to 95%. SQL safe also enables complete "hands-free" automated backup of your entire SQL Server infrastructure and ensures compliance with your organization's backup and recovery policies. From implementations with tens of SQL servers to enterprises with hundreds of servers spread around the globe, SQL safe is the only SQL Server backup and recovery solution th

Learn more!

SQL Server Post SQL Installation Checklist (Part 4 of 4)

By: Chad Boyd | Read Comments | Print

Chad is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server.

Related Tips: More

This is the fourth and final checklist in the process – run through it just after completing a SQL Server installation in any environment.

SQL Clustering Post-Installation Checklist

Activity	Pass	Fail
If antivirus software is installed, set filter to exclude all Sql extensions (data files, snapshots, logs, full text catalogs and indexes), Sql Server program files path, Sql logging/tracing paths
Appropriate SQL Server service pack and hotfixes applied
SQL 2005 – Client tools installed individually on cluster nodes (if desired)
SQL 2005 – SSIS service installed individually on cluster nodes (if desired)
SQL 2005 – SSIS properly installed, configured, etc. for cluster use (if desired)
All SQL Server resources online and configured
Static port number assigned to the instance, protocols configured
Additional disk resources configured as dependencies of the SQL Server resource and verified (fn_servershareddrives or sys.dm_io_cluster_shared_drives)
“Affect the Group” option set correctly for Sql Server 2005 and Analysis Services 2005 resources
Advanced Security (IPSec, Kerberos, or SSL) enabled if appropriate
Verify possible owners list for ALL resources contains appropriate nodes
Preferred owners configured for more than two nodes
Resource group failback policy set (if modifications necessary)
Resource parameters set (if modifications necessary)
Resource group thresholds set (if modifications necessary)
Verify the failover of the SQL Server virtual server to and from all nodes in the cluster
Verify all applications with the failover of the SQL Server virtual server
Appropriate services marked to Not Affect Group and/or removed from cluster control (FTS, Backup drives, etc.)
Verify node participation for the instance (fn_virtualservernodes)
Model database reconfigured appropriately
Enable advanced configuration options
Default data/log file paths reset
Configure tempdb
Maintenance database created and configured on instance
Set appropriate default DB Options on system, model, and existing user databases (using DatabaseOptions.sql script if available)
Security configured appropriately (lockdown script if available)
Default server options configured appropriately (using ServerOptions.sql script if available)
SQL Agent properties configured
Standard jobs, alerts, monitoring systems, procedures deployed to system
Capture MPS Reports (cluster, Sql, Setup/Perf) for each node in the cluster
If desired, installation account (ideally the Cluster Admin account) can have privilege to ADD ACCOUNTS to each of the Domain Groups for Sql Server-related accounts revoked (no longer required)
SqlIoSim run to baseline disk subsystem health and configuration
SqlIo run to baseline throughput limitations of IO system
Clear event logs (if desired) and archiv0065

Related Tips: More | Become a paid author

Last Update: 6/29/2008

Share:

Free SQL Server Learning

Comments and Feedback:

Sponsor Information

Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

It takes just 5 minutes to connect your SQL Databases to source control. Got 5 minutes? Get started now.

We fill in the gaps... SQL Server Training, Development, Performance Tuning, SSIS and more

Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now.

Free Web Cast - Database development best practices by SQL Server MVPs Grant Fritchey and Jeremy Kadlec