Types of Backup and Restore Processes

SQL Server Architecture

SQL Server Architecture

Types of Backup and Restore Processes

Microsoft® SQL Server™ 2000 and SQL Server version 7.0 supports four types of backups. These can be combined to form many different types of backup and restore processes, each customized to the availability requirements of the database. The four types are:

  • Database

  • Transaction log

  • Differential

  • File and filegroup

See Also

Designing a Backup and Restore Strategy