Backup and Restore

Backup on the fly based on previous backups

This script uses the system backup history to run a differential backup and place it in the directory of the last full backup.

Understanding Logging and Recovery in SQL Server

Logging and recovery are critical parts of SQL Server, but they are often poorly understood. Paul Randal gives an overview of how the logging and recovery features work in SQL Server and explains the transaction log and recovery models to help you maintain a better database.

Database Snapshots

Database Snapshots

Create Backups without Breaking the Database Backup Sequence

This article shows how the COPY_ONLY clause can be used to ensure that an ad-hoc database backup do not break the backup sequence

DB Recovery

Restores

Backup and Recovery

Backup and Truncate Transaction Logs

Save the transaction log and truncate the file to prevent Tlogs FULL Error