Need to find corruption or other errors in the ERRORLOG? Here is a T-SQL script I use to search for multiple values in the SQL Server ERRORLOG at once.
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLDB’ is Full Due to ‘DATABASE_MIRRORING’
Error 9002 has many causes. Here I explain the one where the transaction log for database ‘SQLDB’ is full due to ‘DATABASE_MIRRORING’ and what it tells you.
SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable
A command-line SQL Server install failed: Validation for setting ‘AGTSVCACCOUNT’ failed, the RPC server is unavailable. I read the setup log and found the fix.
SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid
A client’s command-line SQL Server install failed with: The specified value ‘Install’ for ACTION is invalid. Here is what the setup log showed and how to fix it.
Backup Error 3636: An Error Occurred While Processing BackupMetadata
Backup error 3636 appeared on a log backup taken on an availability group secondary after a log file was added on the primary. The secondary had not replayed the change. This post shows the queries I use to compare file lists and redo progress, tested on SQL Server 2025.
SQL SERVER – Backup to URL – Script to Perform Striped Backup using Shared Access Signature (SAS)
A reader wanted a striped backup to Azure Blob Storage. Here is my script to take a striped Backup to URL across several files using a SAS token credential.
Msg 3292 in SQL Server: Failure Executing Backup or Restore With a URL Device
Msg 3292 appears when a backup or restore with a URL device fails, and it never names the cause itself. In one 2018 client case the cause was a renamed BackupToUrl.exe. This post shows how to read the companion messages, check the helper file and the credential, and trace the failure.