Maintaining SQL Server in a SharePoint Environment
To keep SharePoint operating smoothly and with optimal performance, it is highly recommended that SharePoint administrators conduct regular maintenance on each SQL Server database. Such maintenance tasks include rebuilding indexes, checking database integrity, updating index statistics, and performing internal consistency checks and backups. Administrators can perform database maintenance tasks either by executing Transact-SQL commands or by running the Database Maintenance Wizard. This section provides information and recommendations for maintaining the databases that host SharePoint data and configurations. Later in this section, administrators will learn how to automate and schedule the ...
Get Microsoft SharePoint 2010 Unleashed 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.
