Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Tracy J Powell: "Thank you VERY much for the quick and helpful response. I will definitely upgrade as soon as possible. Your products are great and I use them daily".
Lynn Armbruster: "Thank you. I found Maestro easy to use and so far a great tool".

More

Add your opinion

Customers
Download Buy

MS SQL Maestro online Help

Prev Return to chapter overview Next

Backup Devices

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

or

•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

or

•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

or

•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.

 


Prev Return to chapter overview Next