Extended Events for Tracking Backup and Restore Progress

Microsoft has introduced new extended events in SQL server 2016 which will give us detailed information about restore and backup process.

The Backup Operator

Managing SQL Server Backup and Restore History Information

Greg Larson explains that SQL Server provides a couple of different ways to delete backup and restore history. If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure. Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.

The RPO

Solve Common SQL Server Restore Issues

Understanding backup and restore processes is essential for developers and DBAs to be more confident when dealing with uncommon situations and having the ability to suggest flexible solutions related to these processes. In this article, Sergey Gigoyan answers some key questions relating to backup and restore.

Backup and Restore Strategies in SQL Server – Part 2

In this article of the series Arshad Ali discusses different types of restore processes and backup and restore scenarios.

Backup and Restore Strategies in SQL Server – Part 1

You need to set up backup and restore strategies to recover data or minimize the risk of data loss in case a failure happens. In this article series, Arshad Ali discusses backup and restore strategies in SQL Server.

Compressed Backups

The 5 Worst Days in a DBAs Life: Day 2

Steve and the rest of the DBA Team are back for round two. In this episode they have to restore all of a business' data using nothing but a set of off-site backups, kanban, and witty repartee.

The Girl with the Backup Tattoo

The DBA Team are back, ready to save another DBA. In this episode, a rogue DBA sabotages the backups, can Robyn Page, Steve Jones, Grant Fritchey, and Phil Factor find the solution? Save the backups...save the business.