A reader using Backup to URL asked how to add the date to a Database Backup Filename. Here is a script that builds the name for you.
Do You Need an Availability Group? Matching RPO and RTO to a Feature
Match RPO and RTO to backups, log shipping, failover clusters, or availability groups, then test the full service recovery path.
When was Database Last Backed Up in SQL Server? – Interview Question of the Week #107
When was each database last backed up? Here is the script I share in training that lists full, differential and log backup history for your server.
SQL SERVER – Performance Analysis of Backup to Azure
Compression saves backup space, but does it save time too? My Performance Analysis of backup to Azure compares timings with and without compression.
SQL Server Backup Compression: How Much Space It Saves
Backup compression needs only the COMPRESSION option in the BACKUP statement. This post backs up a demo database twice and compares the sizes and times. It also checks the restore, explains the error that mixing compressed and plain backups raises, and covers the costs.
SQL SERVER – FIX Error 5120 – Database is in Read Only Mode After Attaching Files
An attached database showed read-only and SET READ_WRITE failed with OS error 5, Access is denied. Here is how to FIX Error 5120 with file permissions.
PowerShell – Script to Listing all Backups Taken with SQL Server
A handy PowerShell script for listing all backups taken for each database on your SQL Server, one I keep on my USB drive for customer visits.