Check Backups

Checking Backups on your SQL Server

Handling Backups for Rapid Resilience

The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth in the typical size of databases. When disaster strikes, and an important service is taken offline while a restore is performed, there is often time to reflect on whether it might be possible to design databases for a more rapid recovery of the most critical parts of a database application.

The Importance of Validating Backups

You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.

Backups

Full Backups

How to Get Information About Your Backups

When you need to restore but aren't 100% sure about the contents of your backup files, what do you do? Head to the headers. Grant Fritchey explains how to find the useful bits in these huge stores of information and make sure you restore the right files.