SQL Server 2005 Clustering Tips/References

I have copied this over from an older blog. I have cleaned it up a bit to clarify a few areas and added some links. SQL Server 2005 Clustering Tips/References This information will supplement the clustering information I wrote in chapter 10 of SQL Server 2005 Practical Troubleshooting: The Database Engine   — Handy cluster related infoContinue reading “SQL Server 2005 Clustering Tips/References”

What to know before you choose a SQL Server Disaster Recovery and/or High Availability solution

Why disaster recovery planning matters: ·         Do you know what your plans are to recover from various data losses? Have you ever tested those plans? Can they be implemented within your Service Level Agreements (SLA)? Are you confident your plans cover the most likely and/or most painful types of data losses? ·         Who gets toContinue reading “What to know before you choose a SQL Server Disaster Recovery and/or High Availability solution”

SQL Server 2005/2008 Now Supports Guest Clustering in a Virtual Machine!

Technorati Tags: SQL Server,virtualization Guest clustering in a Virtual Machine for SQL Server has been a hotly requested feature for quite some time, and as of today it is officially supported! See the below links from Bob Ward for the exact details. Basically the guest OS has to be Windows 2008 or higher, SQL ServerContinue reading “SQL Server 2005/2008 Now Supports Guest Clustering in a Virtual Machine!”

Introduction to Policy Based Management

Thanks to Lara Rubbelke for teaching me about PBM! See the attached PBM.zip for a full slide deck and demos of the “on change” functionality.    Install •       Get updated policies from the feature pack item “Microsoft SQL Server 2008 Policies” •       In Management Studio expand your instance then Management.Policy Management.Policies.Import Policy •       Import from C:Program FilesMicrosoftContinue reading “Introduction to Policy Based Management”

Previous blogs on SQLCommunity.com

Connect.Microsoft.com By Cindy Gross on Monday, March 09, 2009 12:15:56 AM Want to provide feedback on any Microsoft product? Want access to the latest CTPs (sometimes known as betas)?   Create an account on http://connect.microsoft.com/ and you can file bugs or wishes and vote on what other people have submitted. You can also find CTPsContinue reading “Previous blogs on SQLCommunity.com”

How to configure DTC for SQL Server in a Windows 2008 cluster

How to configure DTC for SQL Server in a Windows 2008 cluster [This post was revised 11 May 2009 with new mapping information, fixed formatting issues 23 March 2010] With Windows 2008 you now have the option to use multiple DTCs. There is a lot of confusion over whether to do that for SQL ServerContinue reading “How to configure DTC for SQL Server in a Windows 2008 cluster”