An archive backup is a collection of one or more files that together contain all the required information for the backup, including the main database file, transaction logs, and dbspaces. Archive backups can only be performed as server-side backups, and can be saved to either a file or tape drive.
The following statement makes an archive backup to the first tape drive on a Windows computer:
BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF WITH COMMENT 'May 6 backup';
The first tape drive on Windows is \\.\tape0. Because the backslash is an escape character in SQL strings, each backslash is preceded by another.