Connection timeout expired failed a log shipping restore job at a client. The pre-login handshake alone took about 33 seconds, past the 30 second default. Staggering the jobs and adding -logintimeout 60 to the job step fixed it.
Could Not Log History: Log Shipping Copy and Restore Jobs Fail
The Could not log history error stopped the Copy and Restore jobs of a client’s log shipping. The Agent account was a sysadmin on the primary and secondary, but not on the monitor server. A third Profiler trace showed it.
Msg 3169: Managed Instance Backup Fails to Restore On-Premises
Msg 3169 told a client that a backup from SQL Azure Managed Instance was incompatible with their on-premises SQL Server 2019, even though both showed version 15. Managed Instance backups can only be restored to another managed instance, so we used a BACPAC instead.
Missing tempdb Files: master_files vs database_files
Missing tempdb files show up as a mismatch between sys.master_files and tempdb.sys.database_files. This post compares the two with a query, simulates the missing files on a copy of the catalog, and shows the error log message that gives the cause. The fix is to correct the path and restart.
Error 17182: Unable to Initialize SSL Support in SQL Server
Error 17182 says the client and server do not possess a common algorithm. A client could not install SQL Server 2014 because the build did not support TLS 1.2. Switching protocols, patching and switching back fixed it.
No Custom Security Extensions: SQL Server Upgrade Rule Failure
The No Custom Security Extensions rule failure stopped a SQL Server upgrade because Reporting Services had custom extensions configured. The fix that worked was to clear the extensions in RSReportServer.config, upgrade, and put them back afterward.
Setup Error 1060: The Specified Service Does Not Exist During Upgrade
Setup error 1060 stopped an in-place upgrade from SQL Server 2008 R2 to 2014 right after the product key. The setup log asked for a ReportServer service that no longer existed. Removing the leftover SSRS fixed it.