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.

Identify the Backup used to Restore the Database

This article will help us identify the backup which was used to restore the database. This may seem simple when the database backup is from the same server but the complications begin when the backup is not from the same server.

Script to Get the Backup History

Script to get the database backup history on SQL Server 2000/2005/2008