Backup Database SmartGuide -- Fields and controls

Database page
Availability
Protection
Rate of Change
Recommendation
Database Image
Figure pbullet not displayed. Back
Figure pbullet not displayed. Next
Figure pbullet not displayed. Done
Figure pbullet not displayed. Show Command
Figure pbullet not displayed. Cancel



Database page

Figure pbullet not displayed. Database

Figure pbullet not displayed. Database

This field confirms the database you want to backup. To choose a different database, click on Cancel and invoke the Backup Database SmartGuide from the pop-up menu of another Database object.



Availability page

Figure pbullet not displayed. 5 days a week, 8 hours a day
Figure pbullet not displayed. 5 days a week, 24 hours a day
Figure pbullet not displayed. 7 days a week, 24 hours a day

Figure pbullet not displayed. 5 days a week, 8 hours a day

Click on this radio button if your database is not available exactly eight hours a day, but you can stop it for service at least once a day.

Figure pbullet not displayed. 5 days a week, 24 hours a day

Click on this radio button if your database can only be stopped once a week.

Figure pbullet not displayed. 7 days a week, 24 hours a day

Click on this radio button if your database is never stopped for service.



Protection page

Figure pbullet not displayed. Fast recovery (Circular Logging)
Figure pbullet not displayed. Complete recovery (Archive Logging)

Figure pbullet not displayed. Fast recovery (Circular Logging)

Click on this radio button to record the changes to your database in a set of logs. When the last log file in a series is filled, the first log file is reused in a circular fashion. Circular logging supports restore--only recovery. (LOG RETAIN = OFF)

Figure pbullet not displayed. Complete recovery (Archive Logging)

Click on this radio button to continuously create additional logs to record every transaction since your last backup. Archive logging does not overwrite older log files. This type of logging supports roll-forward recovery. (LOG RETAIN = ON)



Rate of Change page

Figure pbullet not displayed. Slider
Figure pbullet not displayed. Recommended backup frequency

Figure pbullet not displayed. Slider

Use the slider to show the amount of data in the database that changes each day.

Figure pbullet not displayed. Recommended backup frequency

This field shows the time between backups. Scheduling a backup is a trade off between the time it takes to backup the database and the amount of data you can recover (circular logging) or the backup time and the time required to recover all the data (archive logging) after a failure.



Recommendation page

Figure pbullet not displayed. Type of Logging (Protection Page)
Figure pbullet not displayed. Type of backup
Figure pbullet not displayed. Schedule (Availability Page)
Figure pbullet not displayed. Schedule (Rate of Change Page)

Figure pbullet not displayed. Type of backup

Select the type of backup:

Online
The database can be backed up while users or applications are connected. Database performance can be decreased. The backup may take longer.

Offline
No users or applications can be connected to the database. The backup may be faster.

You can do a backup while the database is either online or offline. If it is online, other applications or processes can continue to connect to the database as well as read and modify data while the backup task is running. If the backup is performed offline, only the backup task can be connected to the database. The implication of offline backup is that the rest of your organization cannot connect to the database while the backup task is running. However, online backups are supported only if roll-forward recovery is enabled.



Database Image page

Figure pbullet not displayed. Target location
Figure pbullet not displayed. Add
Figure pbullet not displayed. Change
Figure pbullet not displayed. Remove

Figure pbullet not displayed. Target location

Use this field to type the name of a folder for your database image.

Figure pbullet not displayed. Add

Click on this push button to add a folder to the list.

Figure pbullet not displayed. Change

Click on this push button to change a folder in the list.

Figure pbullet not displayed. Remove

Click on this push button to remove a folder from the list.