Backing Up the Database
The actual process of performing a backup presents as many options as the underlying concepts present.
A backup may copy the data to one of two possible destinations:
- Disk subsystem: You can perform a backup either to a local disk (preferably not the same disk subsystem as the database files) or to another server's disk drive by using the Universal Naming Convention (UNC). The SQL Server service account must have write privileges to the remote drive/share to save the backup file.
- Tape: SQL Server can back up directly to most tape-backup devices.
A disk- or tape-backup file is not limited to a single backup event. The file may contain multiple backups and multiple types of backups.
If the backup file is copied to tape, then media retention or rotation, and the off-site media-storage location, become important.