SQL Server Restore Tutorial

What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.

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.