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 Cluster Configuration Checklist

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 informational sheet should be filled out completely prior to starting the installation/configuration of a new cluster. If you are installing a new SQL Server non-clustered instance, this sheet can still be used for tracking non-cluster details (i.e. MSDTC, DNS, etc.) NOTE: Only include user/password information if secure document – if not, simply reference the location to retrieve.

Cluster Configuration - <insert_cluster_name>

Parameter	Value
Server Cluster Name
Server Cluster Service Account Name
Server Cluster Service Account Password
Server Cluster Domain Name
DNS Server(s)
WINS Server(s)
Server Cluster IP Address
Server Cluster IP Subnet
Cluster Group Name
MS DTC Configuration (configured resource or comclust (Win 2000 only), grouping, etc.) Configured within the cluster resource group	MS DTC Network Name: MS DTC IP Address: MS DTC Subnet:
MS DTC Group Name
MS DTC Group Preferred Owner Order
MS DTC Disk Config
Quorum Type (Shared vs. Local quorum, MNS, Disk configuration) Drive Letter, Log Size	Drive Letter: Log Size:
Number of Nodes
Drives For Cluster Use	See “Disk Configuration Worksheet”
Name of Private Network(s)
Name of Public Network(s)
Cluster Log Size and Location

Related Tips: More | Become a paid author

Last Update: 6/28/2008

Share:

Free SQL Server Learning

Comments and Feedback:

Sponsor Information

Try the award winning SQL diagnostic manager as a free 14-day trial!

Optimize your SQL Server storage: compress live databases by up to 90%. Download a free trial.

Make the most out of SQL Server - Guaranteed Results - Innovative SQL Server DBAs

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

Learn SQL Server 2008, Performance Tuning, Development, Administration, Replication and more - free webcasts