Maintaining the Data Warehouse

Maintenance of the data warehouse is an ongoing task that should be designed before the data warehouse is made available to users. Maintenance involves:

• Implementing a backup and recovery mechanism to protect the data in the event of a system failure, or some other problem.
• Archiving the database. This may be necessary to purge the database of unused historical data, and free up space.
• Running SQL Server Profiler to determine which indexes to create to enhance query performance.

See Also