Odd upgrade bug when using a slipstreamed install
SQL Server 2008 Service Pack 1
Upgrades and Slipstreamed Installations
Patching Clustered SQL Server Instances with SQL Server 2008 and SQL Server 2008 R2
Learn how to properly update a clustered instance of SQL Server 2008 or SQL Server 2008 R2. See the whitepaper for ALL of the details!
Scripting the Addition and Removal of Cluster Nodes as Possible Owners of a Resource
Find out how to properly script adding and removing nodes from a resource in a failover cluster
UPDATE – Combining Clustering and Log Shipping Bug
I’m out here at PASS this week and was in the CAT area. Cindy Gross (who works for MS and blogs here) hooked me up with someone who let me know that what I found back in May (where if you changed your path for install, things like log shipping wouldn’t work after failover) has been fixed. This is GREAT news. The fix can be found in SQL Server 2008 SP1 CU10 and it… Read More
Bug – Combining Failover Clustering & Log Shipping When Programs Installed On Another Drive
A customer of mine contacted me this week about a problem they were having. They have a two-node failover cluster on Windows Server 2008 R2 with an instance of SQL Server 2008 with SQL Server 2008 SP1. They installed SQL Server’s program files to another drive – not the main system drive (C). They then configured log shipping. Everything worked fine until they were testing failover. When the instance was failed over to… Read More
SQLHA Experts Tip #5
Ben DeBow
Partner
Follow:
Always design the database environment top down even if the environment consists of only a couple servers or several hundred. By approaching the design top down, many efficiencies can be gained on every level.