Overview

This article describes the process of creating a maintenance plan in Microsoft SQL Management Studio for GFI Archiver database(s).

Process

If this is a SQL Server Express Edition, you can schedule and automate backups using the Task Scheduler.

If this is a SQL Server, you can create a maintenance plan from Microsoft SQL Server Management Studio, as per the below steps:

1. Log in to the SQL Management Studio using SA (System Administrator) credentials.
2. Expand Management, then right-click Maintenance Plans and select Maintenance Plan Wizard.
3. Click Next and name the plan GFI Archiver DBs.
4. Select Check Database Integrity, Shrink Database, and Rebuild Index and click Next.
   Optional Step: You may also set up Backup Database Task
5. In the Task Order, make sure the tasks are in the order above.
6. In the following 3 screens, make sure that under Databases All Databases is selected.
7. On the final screen click Finish.
8. Double click 'GFI Archiver DBs' to open the maintenance plan and modify the schedule, as per your preferred frequency (decided by a variety of factors).

Note: It is ideal to run maintenance on weekends, or during any other non-working hours so that it does not affect end users while running.