After patching, SQL Server would not start. The SSIS hotfix script failed because database SSISDB is enabled for Database Mirroring. Here is the fix.
Windows Clusters in Different Domains: Deploying a Distributed Availability Group
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.
SQL SERVER – Unable to Add Node – Could not find subkey System \ CurrentControlSet \ Services \ MSSQLFDLauncher. Error code 0x851B0001
Running add node on Node2 failed with “Could not find subkey MSSQLFDLauncher”, error 0x851B0001. The cause was a missing Full-Text MSI in the setup media.
Migrate SQL Server Cluster Storage to New Disks
To migrate cluster storage for a SQL Server failover cluster, add the new disks to the SQL Server role, take the instance offline, copy the files with their permissions, give the new disks the old drive letters and bring the instance back. This post lists every step, the checks to run first, the quorum and MSDTC disks, and the T-SQL alternative that changes file paths.




