backup device

Using a logical backup device can help if you plan to write a series of backups to the same path or to a tape device.

If one backup device fails, one of the mirrors can be used to restore the database.

A backup device is a logical device that corresponds to a resource provided by the operating system (the specified physical device).

Similarly, a backup device that contains nonstriped backups cannot be used in a stripe set unless FORMAT is specified.

The example then backs up the AdventureWorks database to this logical backup device.

Throughput of read and write operations (in bytes per second) for a backup device used when backing up or restoring databases.

All the output to a given single backup device (or group of mirrored backup devices) forms a single media family.

Block size of the physical device containing the file in bytes (not the backup device).

Defining a new logical backup device that uses the original logical device name but maps to a different physical backup device.

If the total read throughput is greater than the total backup device throughput, then the bottleneck is on the backup device side.

This will create an external snapshot and then perform a backup of that snapshot to a backup device such as tape.

Mirroring backup media increases the reliability of backups by providing redundancy for the physical backup device.

The use of RAID for a disk backup device needs to be carefully considered.

A physical backup device is initialized when the first backup in a media set is written to it.

Defining a logical backup device involves assigning a logical name to a physical device.

Is the logical name of the backup device used in the BACKUP and RESTORE statements.

Retrieves all the backup header information for all backup sets on a particular backup device.

A logical backup device lets you use indirection when referencing the corresponding physical backup device .

This may be a local tape drive or a tape-based logical backup device created for the database.

Mirroring a media set increases backup reliability by reducing the impact of backup-device malfunctions.

This may be a system file or a disk-based logical backup device created for the database.

Backup device speed is one potential bottleneck in backup throughput.

A backup script can be written to use a particular logical backup device.

A disk backup device is a hard disk or other disk storage media that contains one or more backup files.

If data backup is required, connect the backup device to the storage server using an extra copper or fiber link.

The Backup Device object provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations.

Cannot locate the specified media or backup device. This backup operation will terminate.

Cannot locate the assigned media or backup device. This backup operation will terminate.

Prepare a backup device for the instance and application databases.

As the sizes of databases grow, the probability increases that a failure of a backup device or media will make a backup nonrestorable.

The following example creates a logical backup device, AdvWorksData, for a backup disk file.

Specifies the type of backup device used when initializing a Subscriber from a backup.

An optional user-defined name that points to a specific physical backup device, such as a disk file or tape drive.

A disk backup device could be a simple disk device, such as an ATA drive.

The database backup is the ninth backup set in the media set on a logical backup device named MyDatabaseBackups.

The backup device from where the transaction log backup will be restored.

The backup device where the full database backup is written.

The backup device from where the full database backup will be restored.

The backup device where the transaction log backup will be written.

The following example restores a full database backup from the AdventureWorksBackups logical backup device.

Creating a backup device simply creates a name or alias for the logical device.

Each mirror requires a separate backup device for each media family.

Specifies if a tape backup device should be unloaded after the initialization from back is complete.

The following example restores a full database backup from a TAPE backup device.

Click New Backup Device, which opens the Backup Device dialog box.

usually , it is better to place each backup device on a separate disk device.

As databases grow, the probability increases that a failure of a backup device or media will make a backup nonrestorable.

Added the "Using a Logical Backup Device" section.

A media set contains one or more media families, each of which corresponds to a backup device.

Use the Backup Device dialog box to view the backup information.

Whether you use a tape backup device or a CD-RW drive, it's important to map out9 a regular backup schedule and to stick to it.

Data written by a backup operation to a backup device that is being used by a media set.

The following example shows adding a remote disk backup device called networkdevice.

Notice that in this statement, you must specify a snapshot name rather than a backup device.

Is the physical name of the backup device.

Hard disk file as a backup device.

One advantage of using a logical backup device is that it is simpler to use than a long path.

Returns a result set that contains information about the backup media on a specified backup device.

The backup device is a logical device.

A writer thread is assigned to each backup device.

For example, the following statement backs up the AdventureWorks database to the AdventureWorksBackups logical backup device.

The backup device is a tape drive.

Q: Friends who use Macs tell me they have a removable backup device that backs up their entire hard drive, including programs.

Is the type of backup device.

This topic explains how to create a tape backup device.

SQL Server 2005 introduces mirroring of backup media sets to reduce the effect of backup-device malfunctions.

Industry: Advertising Gifts; Mobile phone with accessories; Call Monitor; Mobile telephone; Touch screen phone; SIM card backup device;

Industry: Festival Supplies; Advertising Gifts; Mini-style phone; Touch screen phone; Penholder, pen container; SIM card backup device;

Industry: Telephone alarm devices; Mobile Card Reader; Infrared Adapter; Bluetooth Adapter; Mobile phone dual sim; SIM card backup device;

Industry: SIM card backup device; Touch screen phone; Mobile phone charger; Mobile Card Reader; Souvenir; Camping lamp, Flashlight;

Industry: Bluetooth Adapter; Data line; Phone connector; SIM card backup device; Communication cable; Mobile Card Reader;

Industry: Mobile phone dual sim; SIM card backup device; Fixed wireless; Mobile Card Reader; Infrared Adapter; Bluetooth Adapter;

Industry: Infrared Adapter; Bluetooth Adapter; Mobile phone shell; SIM card backup device; Phone protection film; Hubs;

Industry: Infrared Adapter; Bluetooth Adapter; Data line; Mobile Card Reader; Cell phone hands-free devices; SIM card backup device;

Industry: Other mobile phone accessories; Touch screen phone; SIM card backup device; Radio, tape recorder; LED Flashlight;

Industry: Mobile phone with accessories; Advertising Gifts; Notebook; Touch screen phone; SIM card backup device;

Industry: SIM card backup device; Mobile phone dual sim; Phone adapter; Data line; Bluetooth Adapter; Infrared Adapter;

Industry: Mobile Card Reader; Mobile phone dual sim; IC Card; Card; SIM card backup device; Communications equipment agent;

Industry: Data line; Phone connector; SIM card connector; Mobile Signal Jammer; SIM card backup device; Mobile phone dual sim;

Industry: GSM mobile phone; Mobile Card Reader; Mobile phone dual sim; SIM card backup device; Other phone cards; Magnetic Card;

Industry: SIM card connector; Mobile phone dual sim; SIM card backup device; Mobile pendant; Mobile phone sticker; IC Card;

Industry: Diesel fuel; Fuel Oil; SIM card backup device; Mobile phone shell; Phone keys; Integrated companies;

Industry: Cable and equipment; Interphone; SIM card backup device; PHS; Ordinary telephone;

Industry: Mobile phone dual sim; Satellite Mobile Phone; Mobile Card Reader; SIM card backup device; IC Card; SMS System;

Industry: PC Card Reader; Bluetooth Adapter; Infrared Adapter; Data line; SIM card backup device; Sound card;

Industry: Bluetooth Adapter; Data line; SIM card backup device; Nightlight; Mobile phone shell;

Industry: GSM mobile phone; Mobile Phone Battery; Mobile Card Reader; Mobile phone dual sim; SIM card backup device;

Industry: Electrical Product Agent Electrical; GPS System; Toy phone; Car model; SIM card backup device;

Industry: Remote control switch; Dialer; Mobile phone dual sim; SIM card backup device; Other phone cards; Card;

Industry: Mobile phone dual sim; Mobile Card Reader; Mobile Phone Battery; Phone keys; SIM card backup device; IC Card;

Industry: SIM card connector; Phone adapter; Mobile Card Reader; SIM card backup device; Mobile phone dual sim;

Industry: Mobile phone dual sim; SIM card backup device; Ordinary telephone; Mobile Card Reader;

Industry: VoIP phone; Fixed wireless; Mobile phone dual sim; SIM card backup device; GSM mobile phone; Card;

Industry: Mobile phone dual sim; SIM card backup device; Bluetooth Adapter; Mobile Card Reader;

Industry: Interphone; Card; SIM card backup device; Dialer; Fixed wireless;

Industry: Mobile Card Reader; Mobile phone dual sim; SIM card backup device; Other phone cards;

Industry: Other phone cards; Mobile phone dual sim; SIM card backup device; SIM card connector;

To read the media header of the media on a backup device

Industry: GSM mobile phone; Mobile phone shell; SIM card backup device; Phone model;

Specifies a logical or physical backup device to use for the backup operation, as follows

Industry: SMS System; Mobile phone dual sim; SIM card backup device; Router;

To Define a Logical Backup Device for a Tape Drive

Industry: Watches; Dialer; SIM card backup device;

Industry: Mobile phone dual sim; SIM card backup device; SMS System;

Industry: Rain shield; SIM card backup device;

To view the backup sets on a particular backup device

To delete a logical backup device

Adds a backup device to an instance of the Microsoft SQL Server 2005 Database Engine.

How to: View the Properties and Contents of a Logical Backup Device (SQL Server Management Studio)

How to: Define a Logical Backup Device for a Tape Drive (SQL Server Management Studio)

How to: Define a Logical Backup Device for a Disk File (SQL Server Management Studio)

A tape backup device performs slowly after you install Windows Server 2003 SP1 or hotfix 873422