Export (0) Print Expand All  Backup Devices  SQL Server 2000
When creating backups, you must select a backup device for the
data to be backed up to. Microsoft® SQL Server™ 2000 can back up
databases, transaction logs, and files to disk and tape devices.
Disk Devices  Disk backup devices are files on hard disks or
other disk storage media and are the same as regular operating
system files. Referring to a disk backup device is the same as
referring to any other operating system file. Disk backup
devices can be defined on a local disk of a server or on a
remote disk on a shared network resource, and they can be as
large or as small as needed. The maximum file size is equivalent
to the free disk space available on the disk.  If the backup is
to be performed over the network to a disk on a remote computer,
use the universal naming convention (UNC) name in the form
\\Servername\Sharename\Path\File to specify the location of the
file. As with writing files to the local hard disk, the
appropriate permissions needed