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.
To run database maintenance tasks on demand
-
In the console, click , and then click .
-
Under Servers, click the icon that represents the database.
-
Under Tasks, select either of the following options:
-
Click .
-
After the task completes, click .
To schedule database maintenance tasks to run automatically
-
In the console, click , and then click .
-
Under Servers, click the icon that represents the database.
-
Under Tasks, click .
-
On the General tab, check either or both of the following options, then click and specify the schedule for each task.
|
Warning:
|
If you perform these tasks in SQL Server Management Studio, uncheck these options.
|