After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
SQL SERVER – Attaching and Restoring Database in Clustering Generates An Error – Notes from the Field #115
Attaching or restoring a database on a cluster and getting an error? In Notes from the Field #115, Eduardo Castro explains what goes wrong with Clustering.
SQL SERVER – Unable to Bring SQL Cluster Resource Online – Online Pending and then Failed
A SQL Cluster Resource started from services.msc but sat in Online Pending and then failed in Failover Cluster Manager. Here is how I tracked down the cause.
Distributed Availability Groups: Linking Two Sites Without One Big Cluster
Understand distributed availability groups, connect two existing groups across sites, inspect health, and plan recovery without one cluster.
Availability Groups or Failover Cluster Instances
Availability groups or failover cluster instances protect different SQL Server boundaries; compare data copies, shared storage, failover, and cost.
Testing a Failover Before You Need One
Testing a failover reveals connection, data, job, and recovery gaps before an outage; learn to plan a SQL Server drill and record the result.