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