Error 21089 failed the Copy and Restore jobs of a log shipping setup. A Profiler trace showed the jobs raising the error on the monitor server. The SQL Server Agent startup account was not a sysadmin there.
Setup Error 25641: Event File Target Parameter Invalid in SQL Server
Setup error 25641 stopped a SQL Server 2012 installation in a client environment. The ERRORLOG said the filename parameter for the event_file target was invalid. Process Monitor showed Access Denied for the service account on the drive that holds the LOG folder.
SQL SERVER – Strange Error Related to Alias
They immediately paid for Comprehensive Database Performance Health Check and we got online to look at their strange error related to alias.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.
WMI Invalid Class: Patch Rule Fails on Cluster Service Check
A WMI invalid class error can sit behind a patch rule failure that looks like a cluster problem. The rule was Not clustered or the cluster service is up and online. Recompiling the WMI MOF files with mofcomp fixed it for my client.
SQL SERVER – Historical PHYSICAL_ONLY Bug and Version Specific Evidence
A historical SQL Server 2017 Bug affected CHECKDB with PHYSICAL_ONLY and clustered columnstore data. One client observed a dump.
Setup Error 0x800F0831: .NET Framework Install Fails During Upgrade
Setup error 0x800F0831 broke an in-place upgrade from SQL Server 2014 to SQL Server 2016. It is the hex form of exit code -2146498511. The CBS log showed store corruption with a missing package, and installing that package fixed the upgrade.