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

Subscribe to our news:
Partners
Testimonials
Paolo Benjamin T. Briones: "I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".
Jim Salmons: "That is excellent news! I will look forward to a future update with these features. It will be attention to such details that further distinguishes your excellent products from the competition.

As always, I appreciate your great products and your demonstrated customer service is equal to the high quality of your products".

More

Add your opinion

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