General Hardware/OS/Network Guidelines for a SQL Box

I have put together some general guidelines for how you want a server to be delivered to the DBA team for a new SQL Server install. You won’t necessarily use all of them, but consider it a starting point for your SQL Server install standards. Places where it may be common to change the statements areContinue reading “General Hardware/OS/Network Guidelines for a SQL Box”

Checklist for installing SQL Server 2005 as a clustered instance

Checklist for installing SQL Server 2005 as a clustered instance   Windows/Hardware 1)      Verify the Windows cluster is set up per basic best practices and that basic failover works. 2)      Verify you have the latest patches, especially security patches, for Windows. 3)      For Windows 2008: Validate the configuration using “Validate a Configuration” in Failover ClusterContinue reading “Checklist for installing SQL Server 2005 as a clustered instance”