Creating a Backup Device
Before backing up a database, you need to create a backup device to copy the database, transaction log, or file/filegroup. The backup devices can be tapes, disk files, or a network drive. When a disk backup device is allocated, no storage space is allocated until the database backup is performed. Tape drives must be connected to the machine running SQL Server. SQL Server cannot use a tape drive on a remote machine.
NOTE
Network drives use the Universal Naming Convention (UNC), which is \\Servername\Sharename\Path\File, or a locally mapped network drive can be used. Make sure that the user account used by SQL Server has the proper permissions to access the backup file and directory.
To create a backup device using the ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
