Export (0) Print
Expand All

Types of Backup and Restore Processes

SQL Server 2000

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft