Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

File and Filegroup Backup and Restore

SQL Server 2000

File and Filegroup Backup and Restore

Microsoft® SQL Server™ 2000 supports backing up or restoring individual files or file groups within a database. This is a relatively sophisticated backup and restore process usually reserved for very large databases (VLDB) with high availability requirements. If the time available for backups is not long enough to support backing up the full database, subsets of the database can be backed up at different times.

For example, it takes three hours for a site to back up a database, and backups can be performed only during a two-hour period each day. The site can back up half the files or file groups on one night and half the next. If a disk holding database files or filegroups fails, the site can restore just the lost files or filegroups. The site must also be making transaction log backups, and must restore all transaction log backups made after the file or filegroup backup.

File and filegroup restores can also be made from a full database backup set. This allows for a quicker recovery because only the damaged files or filegroups are restored in the first step, not the entire database.

See Also

Using File Backups

© 2015 Microsoft