SQL Server Database Maintenance Best Practices
This section explains how to ensure that your OfficeMate/ExamWRITER databases perform well and do not experience downtime or data loss.
To achieve that, perform the following SQL Server database maintenance tasks:
- Identifying and Fixing Untrusted Foreign Keys
- Managing Data and Log Files
- Rebuilding Indexes
- Updating Statistics
- Detecting Corruption
- Backing Up Data
Before performing these tasks, your database administrator should coordinate with your business managers to determine your optimal daily maintenance window and schedule.
Do not run jobs and third-party exports at overlapping times.
Do not run jobs and third-party exports at overlapping times.
For more information about SQL Server database maintenance, see “Top Tips for Effective Database Maintenance” at https://technet.microsoft.com/en-us/library/2008.08.database.aspx#id0230032. Many of the guidelines in these topics are based on that article.1