A database backup and maintenance plan creates a required task workflow to ensure your FactoryLogix Database is optimized, backed up regularly, and remains free of inconsistencies. 

If something happens to your FactoryLogix Database, you'll want to recover it as quickly as possible with minimum data loss. A solid database maintenance plan also assures that your transaction logs are properly maintained and don't consume all available disk space.

This topic provides an ideal maintenance plan for the FactoryLogix Database. There are many ways to set up a plan, but the goal is to have a simple plan that backs up your FactoryLogix Database during scheduled intervals while also backing up the database transaction logs.

Create a database maintenance plan

The SQL Server Maintenance Plan Wizard helps database administrators create a maintenance plan that the Microsoft SQL Server Agent will run on a regular basis to safeguard your FactoryLogix data. The wizard takes you through each task and its related settings. Although the procedure in this topic doesn't go into granular detail for each option, there is a Help button on each page of the wizard to assist you as you make choices for your maintenance plan.

1. Log onto the SQL Server with a Windows account that has local Administrator rights.

2. Open SQL Server Management Studio.

3. In the Object Explorer, expand the appropriate SQL Server computer/instance name, then expand the Management folder in the tree.

4. Right-click the Maintenance Plans folder, then select Maintenance Plan Wizard.

5. When the Maintenance Plan Wizard displays, select Next. In the Name field, enter FactoryLogix Maintenance Plan, then select Single schedule for the entire plan or no schedule.
   
   
   

   Open

   

6. Select the Change button to change the schedule for this maintenance plan.

7. In the New Job Schedule dialog, select Recurring next to Schedule Type, frequency, for your maintenance plan, select OK, then select Next.
   
   
   

   Open

   

   
   
   

8. Select the tasks you want to perform each time the maintenance plan runs, then select Next. (A description of each task displays when you select its corresponding check box.)
   
   

The default maintenance task order is fine, so you don't need to change it.

9. Select Check Database Integrity, then select Next.
   
   
   

10. Select the FactoryLogix database you want to perform an integrity check on, select the check box for your database, select OK, then select Next.
    
    
    

    
    
    

11. Select the database to have the indexes reorganized, select the check box for your database, select OK, then select Next.

12. Select Tables and views from the Object drop-down to configure the Reorganize Index task, then select Next.
    
    
    

    
    
    

13. Select the database you would like to rebuild indexes, select the check box for your database, then select OK.

14. Select the desired settings for the History Cleanup task, then select Next.
    
    
    

    
    
    

15. Select the database you are backing up, select the check box for your database, then select OK.
    
    

16. Browse to the folder where you want to store backups, then select Next.
    
    
    

    
    
    

17. Select the database transaction log you are backing up, select the check box for your database, then select OK.
    
    
    

    
    
    

18. Define the maintenance cleanup task.
    
    
    

    
    
    

19. Define a location for your backup reports.
    
    
    

    
    
    

20. Review the settings for each maintenance task in the tree, then select Finish to complete the Maintenance Plan Wizard.
    
    
    

    
    
    

21. Verify that all steps for creating the maintenance plan were completed successfully.

22. Use the Report drop-down to view, save, or email the report.

23. When you're finished, select Close to complete the wizard.