How to schedule nightly backups and maintenance

You create maintenance schedules so that Sage 100 Contractor will perform maintenance tasks (such as checking data integrity, creating backup copies of your company databases, and removing expired backup files and history tables) at a time when no other users are logged into the system.

To create a backup and maintenance schedule

1. Connect to Database Administration as an SQL and company administrator.
2. Click Schedule Nightly Maintenance and Create Maintenance Schedules.
3. Select the checkbox beside each company that will follow this maintenance schedule on the Create Maintenance Schedules tab.
4. Select the time to perform maintenance for these companies from the Select the time for nightly maintenance list.
5. Select the length of time to maintain backup files for these companies from the Select the number of backups to keep list.
6. Click Save Schedule.