Backup & Recovery

From SQLServerPedia

Jump to: navigation, search

See Also:Main_Page -Database Administration

SQL Server Backup & Recovery Topics

SQL Server Backups

SQL Server Backup Basics - includes a short 10-minute video on the basics of backups.
Optimal Times for Backups
Recovery Models
Types of Backups
Database Snapshot Files
Verifying the Validity of Backups
Backup Performance

Restoring SQL Server Backups

Restoring Full & Differential Database Backups
Restoring Transaction Log Backups
Restoring File/Filegroup Backups - includes a 10-minute video tutorial for SQL Server 2000 and 2005 filegroup restores.
Restore With Standby - includes a 5-minute video and demo T-SQL scripts.
Backing Up & Recovering System Databases
Recovering User Databases
Recovering the Database from an .MDF File
Restoring User Databases to Different Environments
Create disaster recovery scripts automatically

Retrieved from "http://sqlserverpedia.com/wiki/Backup_%26_Recovery"