Backup Devices Wizard (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Wizards

The Backup Device Wizard lets you add a disk or tape backup device to a SQL Server instance. Backup devices store backups of databases and transaction logs.

Before you can dump a database or its transaction log, first link to a backup device that stores the resulting backup file.

To create a new backup device using a wizard:

  1. Open a creation wizard for a backup device. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Backup Devices (SQL Server) - Properties

When creating or editing a backup device, this tab/panel lets you work with the following settings:

Setting Description


Lets you provide a logical name for the backup device.

Device Type

DISK and TAPE are supported.

Physical Name

The physical name of the device. This value can be any simple file name (sqltable.dat for example) or full path (a:\sqltable.dat for example) that is recognized by the operating system.