Backup Devices Wizard (SQL Server)
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:
- Open a creation wizard for a backup device. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Backup Devices (SQL Server) - Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- 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 |
|---|---|
|
Name |
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. |