Scheduled Backup dialog

Show all hidden content
Use this dialog to schedule recurring backups for SQL data locations.
To open this dialog, choose
File
Backup
, choose
Database Locations
from the drop-down list at the top of the dialog, and then select the
Schedule Recurring Backup
button.
note
  • The recurring backups will create up to 10 file backups. After 10 backups have been created, the process will return to the first backup and begin sequentially overwriting backups as additional backups are created. The file names for the backups will end with [SB0].bak, [SB1].bak...etc
  • Because an SQL database holds all the data for any programs that use it in one database file, it is not possible to restore specific files or clients. You have to restore the whole database file, which includes all files and clients.

Fields & buttons

Schedule backups to occur
Mark this checkbox to enable scheduled backups of the selected data locations.
Frequency button
Use this button and choose how often you want the backups to occur.
Time
Enter in this field a time of day at which you want backups to occur, or choose a time using the arrow buttons.
Database location
Choose a database location from this field or choose
<<all database locations>>
.
Backup location
Displays the current backup location.
Modify Backup Location
Use this button to choose a new backup location. Navigate to the new location in the dialog that opens and select
OK
.
User name
Enter your Windows user name in this field.
Password
Enter your Windows password in this field.