Backup Database Configuration and Maintenance Plan - PAS ICS Integrity - 7.3 - Installation & Upgrade - Intergraph

This section guides you through the process of creating the folder where backup files are stored and creating the Maintenance Plan to perform the backups.

To create a backup folder and maintenance plan to back up the database:

1. Enable Agent XPs. For more information, see Agent XPs Server Configuration Option in Microsoft SQL Server documentation.

2. Create a folder on the SQL Server for storing the backup files named Integrity_Backups.

3. In the folder you created, create a subfolder named Logs.

4. Start SQL Server Management Studio.

5. Connect to the Database Engine using the credentials supplied on site.

6. Expand Management in the Object Explorer window in the left pane.

7. Right-click Maintenance Plans and click Maintenance Plan Wizard.

8. If an Introduction window is displayed, click Next.

9. Specify the following information on the Select Plan Properties window:

   Name: Type a name. For example, Integrity.

   Description: Type an optional description.

   Select Single schedule for the entire plan or no schedule.

10. Click Change.

11. On the Job Schedule Properties window, set the Frequency, Daily frequency, and Duration as appropriate, based on how often data imports occur (usually weekly). If possible, schedule the maintenance job for a period when no imports occur.

12. Click OK to close the Job Schedule Properties window.

13. Click Next.

14. On the Select Maintenance Tasks window, select Back Up Database (Full) and Maintenance Cleanup Task, and then click Next.

15. Use the Move Up or Move Down buttons to re-order the tasks so Maintenance Cleanup Task is first, and Back Up Database (Full) is second, and then click Next.

16. On the Define Maintenance Cleanup Task window, set the fields as follows:

    1. Under Delete files of the following type, click Backup files.

    2. Under File location, click Search folder and delete files based on an extension.

    3. In the Folder text box, type the path you created in Step 1, such as D:\Integrity_Backups.

    4. In the File extension text box, type bak.

    5. Select Include first-level subfolders.

    6. Under File age, select Delete files based on the age of the file at task run time.

    7. In Delete files older than the following, set the time period based on how many backups you want to keep. For example, to keep four weekly backups, set the delete parameters to 4 weeks.

17. Click Next.

18. On the Define Back Up Database (Full) Task window, select the Integrity database in the list of databases, and then click OK.

19. On the Destination tab, select Create a backup file for every database, and then in the Folder text box, type the path to the backup location you created in Step 1, such as D:\Integrity_Backups.

20. Select Create a sub-directory for each database.

21. On the Options tab, change Set backup compression to Compress backup. All versions of SQL Server 2008 R2 or later have these options. Then click Next.

22. On the Select Report Options window, select Write a report to a text file.

23. In the Folder location text box, type the path for the logs you created in Step 2, such as D:\Integrity_Backups\Logs, and then click Next.

24. Click Finish, and then make sure the plan creates successfully.