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