Backup Devices Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Backup Device editor lets you view key properties for a backup device.

To edit a backup device

  1. Open an editor on the backup device. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Displays the following property values: Name - the logical name. Device Type - DISK or TAPE. Physical Name - A file name (sqltable.dat for example) or full path (a:\sqltable.dat for example) identifying the device.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.