Scheduling automatic database maintenance tasks
|Article:HOWTO55340|||||Created: 2011-06-29|||||Updated: 2011-12-16|||||Article URL http://www.symantec.com/docs/HOWTO55340|
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:
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
To schedule database maintenance tasks to run automatically
Article URL http://www.symantec.com/docs/HOWTO55340