Maintaining SharePoint's SQL Server Database
One of the most important components of any SharePoint implementation is the database itself. All functionality, configuration settings, and documents are stored within the various SQL databases, and great care should be taken to implement a robust maintenance plan.
Establishing a SQL Server Maintenance Plan
For SQL Server databases to perform at optimal levels, it is recommended that a SharePoint administrator conduct routine maintenance on each database. Some of these routine database tasks should involve rebuilding indexes, updating index statistics, and performing internal consistency checks and backups. These routine database maintenance tasks are often overlooked because they are redundant, tedious, ...
Get Microsoft® SharePoint™ 2003 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
