SQL Server Backup (General Tab)
Use this tab to view or specify the following options.
Options
Database
Specify the database to back up.
Name
Specify the name of the database backup.
Description
Describe the database backup.
Database – complete
Perform a complete database backup.
Database – differential
Perform a differential database backup. A differential backup records only the changes made to the data in the database after the last full database backup.
Transaction log
Back up the transaction log.
File and filegroup
Specify the file name and filegroup to back up. Click the browse (...) button to search for a file or filegroup.
Tape
Back up the database to a tape device.
Disk
Back up the database to a disk device.
Add
Add a backup destination.
Remove
Remove the selected backup destination.
Contents
View the contents of the selected tape or disk.
Append to media
Append the backup to an existing media. The previous contents of the media remain intact, and the new backup is written after the end of the last backup on the media.
Overwrite existing media
Specify to overwrite any existing media. By overwriting backups on media, the existing contents of the backup media are overwritten with the new backup and therefore are no longer available.
Schedule
Schedule a database backup. Click the browse (...) button to view the current backup schedule.