Page History

Backs up either individual files or all files in a filegroup within a database. Backing up single files or filegroups allows you to restore only corrupted files. Restoring only corrupted files increases recovery speed. Consider file and filegroup backups when your database has one or all of the following attributes:

• Database size hinders regular full or differential backups
• Database can be unavailable for short periods of time only
• Specific files are either regularly corrupted, are more critical, or change more frequently than others

You can back up files or filegroups and transaction logs at the same time.