A huge transaction log file has a named reason in log_reuse_wait_desc. This post builds a small demo database, reads that reason, backs up the log and finds the open transaction that holds it. It ends with a one time shrink and a safe growth step.
SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata
Log backups on an Always On secondary replica suddenly failed for my client. Here is how I fixed error 3636: An error occurred while processing BackupMetadata.
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.
SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)
Backup to URL can connect to Azure storage with a SAS token. I share a script that generates the credential and the backup command using a Shared Access Signature.
SQL SERVER – Msg 3292: A Failure Occurred While Attempting to Execute Backup or Restore With a URL Device Specified
My client’s backup to Azure failed with Msg 3292: a failure occurred while attempting to execute Backup or Restore with a URL device. Let me show you the fix.
SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys
Backup to URL can use a SAS token or access keys. Here is a script that builds the CREATE CREDENTIAL and BACKUP commands from your Azure storage access keys.
How to Find Last Full Backup Time and Size for Database? – Interview Question of the Week #173
Too many DBAs I meet have no recent backup. Here is a script that shows when each database had its last Full Backup and how big that backup was.