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.

A Self-Serve System that Allows Developers to Refresh Databases (Part 2)

Dive deep into the details of part 2 in this series of creating a solution so Developers can start a restore of Production to test.

Default Backups and Feature Awareness

Default backup schemes for databases would be a nice enhancement.

A Self-Serve System that Allows Developers to Refresh Databases (Part 1)

Empower developers to refresh their own test systems with production backups.

Using Backup Encryption with an External Certificate

Learn how to load an external certificate into SQL Server to encrypt your backups.

5 reasons why backup and restore doesn’t cut it in dev and test

The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.

VLF truncation in SIMPLE recovery model

I recently presented a session on log file management where I discussed monitoring and managing the logical segments of the transaction log known as Virtual Log Files, or VLFs....

Generate Restore Database Commands

Restoring a database backup from one server to another, or from one database to another on the same machine, often requires MOVE ... TO ... commands. For databases with...