Types of Backups

SQL Server 2000 supports four main types of backups:

  • Full Database Backup

  • Differential Database Backup

  • File and Filegroup Backup

  • Transaction Log Backup

Full Database Backup

Full Database Backup creates a consistent image of the database up to the point that the database backup finished. SQL Server 2000 does this by noting the Log Sequence Number (LSN) at the start of a backup. An LSN is a number assigned to each record written to the log, to keep track of changes. It then copies the extents that make up the database (an extent is a block of eight pages—for more information on extents and database storage structures, see Chapter 33, “SQL Server Internals”). As this is a dynamic backup it allows changes to the data while the backup ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial