Maintaining a Site Database Overview

SMS uses SQL Server to store data about sites and about the resources in those sites. In the SMS Administrator console, you can use Database Maintenance to perform general database maintenance tasks.

Under Database Maintenance, you can use Tasks to run predetermined operations such as exporting the SMS site and software metering databases and logs, deleting old or unneeded data, and rebuilding indexes to improve database performance. You can use SQL Commands to run any valid SQL command. (For example, you can run a DBCC command.) You can also save and review the results of all commands that are run.

Related Topics

Topic Link

Database Maintenance Tasks Overview

Topic Link

Database Maintenance SQL Commands Overview