Log backup on secondary replica fails with error 35296 when the replica sits in the secondary availability group of a distributed availability group. A client hit it on the fourth node of their topology. It is by design, so the backup has to run on a replica that talks to the global primary.
Setup Error 1639: Invalid Command Line Argument in SQL Server
Setup error 1639 stopped my SQL Server 2019 install with an invalid command line argument message. The real clue was in the log: a component from an earlier incomplete install was still there. Uninstalling it with msiexec fixed the problem.
msdb Upgrade Error 916: Fix the Database Owner
A msdb upgrade error can stop the service at the last upgrade step. The post reads the ERRORLOG, shows a read-only owner check, and walks through the four steps that fix the owner of msdb. The fix is one ALTER AUTHORIZATION statement.
Logical Name Mismatch: master_files vs database_files
A logical name mismatch means sys.master_files and sys.database_files disagree about a file name. A tested demo shows both views on one server, and a script checks every database. The post explains the secondary replica case and its fix.
DBCC CLONEDATABASE Error Msg 2601: Cannot Insert Duplicate Key Row in sys.sysowners
A DBCC CLONEDATABASE error that names sys.sysowners points at a database user name, not at the database owner. The queries here find the conflicting user in model and in the source database, and I tested them on SQL Server 2025 along with a clean clone.
SQL SERVER – DBCC CLONEDATABASE Error: Cannot Insert Duplicate Key Row In Object ‘sys.sysschobjs’ With Unique Index ‘clst’.
Investigate a DBCC CLONEDATABASE sys.sysschobjs error with supported catalog checks, original screenshots and a distinct build-specific fix.
Transient Error in Automatic Seeding: Availability Database Failed to Seed
A transient error stopped automatic seeding of an availability database. The ERRORLOG on the secondary showed Msg 4353 about conflicting file relocations. Renaming a logical file let the database seed.