Online Documentation for SQL Administrator for SQL Server
Backup database
Backup node is used for managing backups of the server.
To open a backup tab choose the Maintenance | 
Backup node of the Server Explorer tree.
Use the context menu or buttons on the work area toolbar to manage backups:
create a new maintenance plan
create a database backup
create and print the report
The upper area is the grid with the following columns: Database Name, Recovery Model, Has Backups, Has Backup Schedules, Last Backup Date, Last Execution Outcome, Schedule Period during a Month (It represents a grey axis with points which correspond to 6-hours intervals, days and weeks. Green lines show the planned time of the backup.).
If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.
When you choose a particular database the lower area displays the following detailed information about the backup database maintenance plans: Backup Maintenance Plan/Job: Name, Enabled, Last Run Outcome, Last Run Date; Schedule: Schedule Name, Enabled, Description; Task/Job Step: Name, Last Run Outcome, Last Run Duration, Last Run Message.
To open a maintenance plan in the Maintenance Plan Editor, double-click it in the grid or select it and press the 'Enter' button. Alternatively, you can right-click the maintenance plan alias and select the Edit Plans/Jobs context menu item.
The Backup section has the following nodes:
|
See also: |
