Scheduling automatic database maintenance tasks

Article:HOWTO55340  |  Created: 2011-06-29  |  Updated: 2011-12-16  |  Article URL http://www.symantec.com/docs/HOWTO55340
Article Type
How To


Subject


Scheduling automatic database maintenance tasks

After you install the management server, the space in the database grows continually. The management server slows down after a few weeks or months. To reduce the database size and to improve the response time with the database, the management server performs the following database maintenance tasks:

  • Truncates the transaction log.

    The transaction log records almost every change that takes place within the database. The management server removes unused data from the transaction log.

  • Rebuilds the index.

    The management server defragments the database table indexes to improve the time it takes to sort and search the database.

By default, the management server performs these tasks on a schedule. You can perform the maintenance tasks immediately, or adjust the schedule for when users are not on their computers.

Note:

You can also perform the database maintenance tasks in Microsoft SQL Server Management Studio. However, you should perform these tasks in either Symantec Endpoint Protection Manager or Management Studio, but not both. See the knowledge base article: Create database maintenance plans in MS SQL Server 2005 using SQL Server Integration Services (SSIS).

To run database maintenance tasks on demand

  1. In the console, click Admin, and then click Servers.

  2. Under Servers, click the icon that represents the database.

  3. Under Tasks, select either of the following options:

    • Truncate Transaction Log Now

    • Rebuild Indexes Now

  4. Click Run.

  5. After the task completes, click Close.

To schedule database maintenance tasks to run automatically

  1. In the console, click Admin, and then click Servers.

  2. Under Servers, click the icon that represents the database.

  3. Under Tasks, click Edit Database Properties.

  4. On the General tab, check either or both of the following options, then click Schedule Task and specify the schedule for each task.

    • Truncate the database transaction logs. The default schedule for this task is every four hours.

    • Rebuild Indexes. The default schedule for this task is every Sunday at 2:00.

    Warning:

    If you perform these tasks in SQL Server Management Studio, uncheck these options.

See Scheduling automatic database backups.


Legacy ID



v54457554_v59371754


Article URL http://www.symantec.com/docs/HOWTO55340


Terms of use for this information are found in Legal Notices