Confirms the database that you want to back up. To choose a different database, click Cancel to close this wizard and then right-click another database object and select Backup Using Wizard.
Select this if your database can be stopped at least once a day for service.
Select this if your database can be stopped at least once a week but not daily for service.
Select this if your database cannot be stopped for regular service.
Records 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. (LOGRETAIN=NO)
Continuously creates 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. (LOGRETAIN=RECOVERY)
Shows the amount of data in the database that changes each day. The default is 80%.
Shows the time between backups. Scheduling a backup is a trade-off between the time it takes to back up 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.
Saves log files (recommended).
The database can be backed up while users or applications are connected. Database performance can be decreased. The backup may take longer.
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. However, online backups are supported only if roll-forward recovery is enabled.
No users or applications can be connected to the database. The backup may be faster.
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.
Opens the Schedule window, where you can change the monthly backup schedule.
Lists the directories that store the database backup image.
Use the Add, Change, and Remove push buttons to define all locations of the database image files.
Removes a folder from the list.