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
An amber warning lamp standing alone on wet concrete in a dark plant room

SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. An OS Call Failed: (80090350)

August 1, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Computer Network, SQL Error Messages, SQL High Availability, SQL Mirroring, SQL Server, Windows

Connection handshake failed with 0x80090350 on an availability group replica. What the code means, why it says mirroring, and what to check.

Read More
Gouache painting of a warning sign on an interrupted backup bridge to cloud storage

Backup Error 3636: An Error Occurred While Processing BackupMetadata

July 19, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Backup and Restore, SQL Error Messages

Backup error 3636 appeared on a log backup taken on an availability group secondary after a log file was added on the primary. The secondary had not replayed the change. This post shows the queries I use to compare file lists and redo progress, tested on SQL Server 2025.

Read More
Microsoft Cluster Service errors dialog box.

SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 3

June 8, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster

Part 3: one more reason SQL Server setup can fail the MSCS cluster verification errors rule during install or AddNode, as seen at a client, and the fix.

Read More
SQL SERVER - Always On Replica Disconnected After Changing SQL Server Service Account

SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account

June 1, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Login, SQL Server, SQL Server Security

After I changed the SQL Server service account in my lab, the Always On secondary replica went disconnected. Here is why the endpoint rejects the new account.

Read More
SQL SERVER - Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction

SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction

May 30, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Registry, SQL Error Messages, SQL High Availability, SQL Server, SQL Server Cluster

A client’s SQL Server 2016 Installation in Cluster hung at RunRemoteDiscoveryAction while setup ran discovery on the other node. Here is the cause of the delay.

Read More
Six paintbrushes jammed into one small jar at once, a red brush waiting on a rag beside it

SQL SERVER – Parallel Redo on AlwaysOn Secondary – DIRTY_PAGE_TABLE_LOCK

May 24, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Parallel, SQL High Availability, SQL Server, TraceFlags

Redo lag and high DIRTY_PAGE_TABLE_LOCK waits hit a client’s AlwaysOn secondary. Here is how Parallel Redo in SQL Server 2016 causes them and what to do.

Read More
Diagram of two Windows clusters in different domains: availability group HA_AG with nodes N1 and N2 on one side, DR_AG with nodes N3 and N4 on the other, joined by an async distributed availability group HA_DR_AG

Windows Clusters in Different Domains: Deploying a Distributed Availability Group

April 18, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL High Availability, SQL Server, SQL Server Cluster

After a merger, a client had Windows clusters in different domains that were connected but not trusted, and no wish to use certificates. Here are the steps I shared to deploy a Distributed Availability Group with NTLM pass-through authentication.

Read More
Previous 1 … 3 4 5 6 7 8 9 … 14 Next
  • Books
  • Testimonials
  • Privacy Policy

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