SQL Server maintenance jobs
To optimize Dynamics GP performance, it is recommended to set up a SQL Server Maintenance Plan to perform a number of maintenance and optimization tasks. The following are the steps to create a typical SQL Server maintenance plan for Dynamics GP. The specific steps for your plan may vary, depending on your needs and setup.
- In SQL Server Management Studio, expand your SQL Server instance in the Object Explorer and then expand the Management folder. Right-click on Maintenance Plans and select Maintenance Plan Wizard:
- Click on Next on the Maintenance Plan Wizard window.
- Give your maintenance plan a Name and (optionally) a ...