Tag Archives: backup

Limit the Blast Radius

You still need DBAs (that know how to back up systems and test restores). If you think you don’t, or if you manager does, then perhaps they ought to read this piece on how an AI agent deleted a production … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

Creating a Striped Backup Set with AI

I needed to test a striped backup, so I decided to ask the AI’s for help. This is part of a series of experiments with AI systems. The Problem A customer wanted to know if we could handle a large … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

Making a PostgreSQL Backup in a Container

I needed to back up a PostgreSQL database as a part of the repro for an issue I had. I hadn’t ever made a backup of PostgreSQL, so this was a learning exercise for me. Plus, a container made it … Continue reading

Posted in Blog | Tagged , , | Comments Off on Making a PostgreSQL Backup in a Container

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server accurately tracking history across time and noted they hadn’t cleaned any … Continue reading

Posted in Blog | Tagged , , , | 1 Comment