This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Diagram of Failover Cluster Manager showing Online Pending while the SQL Server service is started: the IsAlive connection check fails with login timeout expired, so the resource never turns Online

Bring SQL Cluster Resource Online When It Sits in Online Pending

August 14, 2015
Pinal Dave
SQL Tips and Tricks
SQL High Availability, SQL Server, SQL Server Cluster

A client could start a SQL Server instance from services.msc but could not bring SQL cluster resource online in Failover Cluster Manager. Here is how I checked the connection and found the cause: a TCP alias with an old port.

Read More
Two hill farms in separate valleys linked by one cart track over the ridge, a red cart traveling between them

Distributed Availability Groups: Linking Two Sites Without One Big Cluster

November 27, 2012
Pinal Dave
SQL Tips and Tricks
AlwaysOn, DBA, SQL High Availability, SQL Server Cluster

Understand distributed availability groups, connect two existing groups across sites, inspect health, and plan recovery without one cluster.

Read More
Two lighthouses on separate headlands at dusk, one lamp lit and one dark but ready.

Availability Groups or Failover Cluster Instances

July 8, 2012
Pinal Dave
SQL Tips and Tricks
AlwaysOn, DBA, SQL High Availability, SQL Server Cluster

Availability groups or failover cluster instances protect different SQL Server boundaries; compare data copies, shared storage, failover, and cost.

Read More
A lifeboat sliding down its slipway into a calm harbor during a practice launch, crew seen from behind.

Testing a Failover Before You Need One

February 5, 2012
Pinal Dave
SQL Tips and Tricks
AlwaysOn, DBA, SQL High Availability, SQL Server Cluster, Testing

Testing a failover reveals connection, data, job, and recovery gaps before an outage; learn to plan a SQL Server drill and record the result.

Read More
Previous 1 … 8 9 10 11
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com