Find Latest Backup

Finds the last full backup file stored in a given folder.

Backup to multiple files for faster and smaller SQL Server backup files

Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.

Mask PII data (Personally Identifiable Information)

When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.

Restoring after TRUNCATE TABLE

Default Backup Directory

Streamlining granular recovery for SharePoint, with Red Gate and Metalogix

We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:

Point-in-time restore

Dynamically Script Database Backups

Dynanically Generate Backups with Date and time

Backup and Housekeeping with Maintenance Plans

Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.

Powershell Database Backup Script

Learn how to write a script for regular database backups using Powershell and SMO.