SQL Safe supports four standard database backup types:
- Full Backup.
- Differential Backup.
- Transaction Log Backup.
- File Backup.
You can use a backup type exclusively or combine types to fit your backup strategy.
...
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.
scroll-pagebreak