Database Backup Types

Getting a List of the Striped Backup Files

If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.

Restoring Expired Certificates

Always Check on the Basics

The basics are important, especially with regards to backup and restore in SQL Server.

Restore databases on SQL Server 2017

Azure VM SQL Database Backups

Clearing Backup History

Temporary data and Differential Backup size

Using Extended Events To Capture Backup and Restore Progress

If you are running a DATABASE BACKUP or RESTORE command manually, SQL Server will show you the progress at a specified % completion interval. For the BACKUP, the default is...
The...

A Self-Serve System to Refresh Databases (Part 3)

This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.