SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

MS SQL Maestro online Help

The Backup Device object provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations. Creating and editing of such devices does not perform any access to the physical device. Access to the specified device only occurs during the backup and restore process.

Creating a logical backup device can simplify backup and restore operations where specifying the device name is an alternative using a 'tape' or 'disk' clause to specify the device path.

Problems connected with ownership and permissions can interfere with the use of disks or file backup devices. Make sure that the appropriate file permissions are given to the Windows account under which the Database Engine was started.

Note: Creating and editing of Backup Device are required for members of the diskadmin fixed server role.

New backup devices are created within Create Backup Device Wizard. In order to run the wizard you should either

•	select the Backup Devices list or any object from that list and then use the Create New Backup Device item from the popup menu

•	open the server in Server Editor and the Backup Devices tab there and press Insert or select the Create New Backup Device item from the popup menu (Alternatively, use the corresponding link of the Navigation Bar).

Backup devices are edited within Backup Device Editor. In order to open the editor you should either

•	select the backup device for editing in the explorer tree (type the first letters of the backup device name for quick search);

•	select the Edit Backup Device item from the popup menu

•	open the server in Server Editor and the Backup Devices tab there;

•	select the backup device to edit;

•	press the Enter key or select the Edit Backup Device item from the popup menu (alternatively, you can use the corresponding link of the Navigation Bar).

To drop the existing backup device:

•	select the backup device to drop in the explorer tree;

•	select the Drop Backup Device item from the popup menu

•	open the server in Server Editor and the Backup Devices tab there;

•	select the backup device to drop;

•	press the Delete key or select the Drop Backup Device item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.

MS SQL Maestro online Help

Backup Devices