Database Maintenance Essentials
SQL Server requires a minimal level of maintenance to ensure that the platform functions at an optimum level without any unnecessary outages or problems. This talk will look at the basics of the maintenance operations that should be performed on SQL Server on a regular basis. The topics covered include:
- Managing MDF and LDF Files
- Managing Indexes
- Maintaining Statistics
- Checking for Corruption
- Creating Backups
That Will RestoreManaging Maintenance JobsI cover the reasons why maintenance is required and include a number of references to help you enable this maintenance in your environment.
Sorry, there are no downloads available for this session.
Steve Jones is currently the editor of SQLServerCentral, employed by Red Gate Software. Steve has been working with SQL Server for two decades at a variety of large and small companies. Steve has spent time as a hiring manager as well as a technical DBA, easily moving back and forth between these positions at different employers. He has managed Windows networks, functioned as a production DBA, development DBA, software developer, and DBA manager. His work has included start-up as well as Fortune 1000 companies in the power, financial, education, and software industries. He currently has his dream job managing the largest SQL Server community on the Internet from his ranch in Colorado and writes a daily editorial at SQLServerCentral.
The video is not available to view online.