Welcome to the Cyara Knowledge Center

It is important to have established procedures to assure proper database maintenance and backup activities are being performed regularly. This is to ensure a speedy recovery after a database crash and also for optimum database operations.

Described below is a recommendation for maintaining the Cyara Portal MSSQL Server database.

Open the SQL Server Management Studio,for example by choosing Start -> Programs -> Microsoft SQL Server 2008 -> SQL Server Management Studio.

Expand Management and right-click on Maintenance Plans. Choose Maintenance Plan Wizard.

Click Next to proceed past the start page and to the first step of the wizard. Type a name for the maintenance plan. Select Single schedule for the entire plan or no schedule. This means that the maintenance plan will run all the task in the plan. Also select the schedule required by clicking on the Change button. In this example, Not scheduled (on Demand) is used. Click Next.

In the Select Maintenance Tasks page, select Check Database Integrity, Shrink Database, Reorganize Index, Update Statistics and Back Up Database (Full). Click Next.

On the Select Maintenance Task Order page, use the Move Up and Move Down buttons to arrange the tasks in the following order and then click Next.

• Back Up Database (Full)
• Shrink Database
• Reorganize Index
• Check Database Integrity
• Update Statistics

In the Define Back Up Database (Full) Task page, click the down-arrow to the right of Databases and choose the Cyara portal database from the list. Click OK to close the database selection window.

Choose the media for the backup (i.e., Disk or Tape) and the location for the backup. Select Verify backup integrity. Click Next.

In the Define Shrink Database Task page click the down-arrow to the right of Databases and choose Cyara portal database from the list. Click OK to close the database selection window and click Next.

In the Define Reorganize Index Task page, click the down-arrow to the right of Databases and choose the Cyara portal database from the list. Click OK to close the database selection window. Accept the defaults and Click Next.

In the Define Database Check Integrity Task page, click the down-arrow to the right of Databases and choose the Cyara portal database from the list. Click OK to close the database selection window. Accept the defaults and Click Next.Click Next.

In the Define Update Statistic Task page, click the down-arrow to the right of Databases and choose the Cyara portal database from the list. Click OK to close the database selection window. Accept the defaults and Click Next.Click Next.

In the Select Report Options page, choose how to have the maintenance plan generate reports. Click Next.

In the Complete the Wizard page, click Finish.

The Maintenance Plan created is not scheduled and has to run manually. To run the maintenance plan do the following steps.

First ensure that the SQL Server Agent is running.

Right click on the newly created maintenance plan and select Execute.

The maintenance plan should run to completion if there are no errors. View report if required or click Close when finished.