Exact MAX Support

Setting Up a SQL Maintenance Plan

Create SQL Maintenance Plan:

In SQL Management Studio ensure the SQL Agent is running. Jobs will not run unless this service is running. Make sure the service is set to automatic.

1. Select the Maintenance Branch, right click and select the Maintenance Wizard
2. Check the following and set all routine maintenance to run on the weekend and set the full backup to run nightly and select the \SQLBackup established during the SQL Server install process.
   1. Log into Management Studio
   2. Expand the Management Tree to expose Maintenance Plan
   3. Right Click and Execute the Wizard
   4. Select to use a separate schedule for each
   5. Discuss the Backup plan with Local IT and make sure they know where to get the .bak files \SQLBackup folder.
3. Note the time for each in the chart below