A patch failed at “Upgrading subscription settings and system objects in database” with invalid object MSreplication_subscriptions. Here is the fix.
SQL SERVER – Unable to Failover SQL Server Instance – Error: Registry Information is Corrupt or Missing
A client could not failover SQL Server to another node: registry information is corrupt or missing. Here is how I found the right error in the logs.
How to Write Errors in Error Log? – Interview Question of the Week #175
How to write errors in Error Log? A customer asked this in my performance tuning workshop, and here is how to add your own messages to the SQL Server log.
SQL SERVER – Databases Going to Recovery Pending State Randomly
A client’s databases kept going to recovery pending state randomly. The ERRORLOG showed why. Here is how I found the cause and fixed it.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing
A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Adding Analysis Services to SQL Server 2014, the Installation Wizard hung on “Please Wait” at feature selection, even after my lunch. Here is what fixed it.
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
SQL Server Agent would not start, and the log said Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed. Here are the logs I check and the fix I found.