Presenter: John Miner of Sensata Technologies
Topic: Designing Custom Maintenance Plans with TSQL
Have you ever received a call from a client asking for help when their SQL Server database is corrupted? You suggest that they restore the database from the last good backup. There is a long pause on the phone as the client states that the only backups/tapes they have are bad. Do not let this situation happen to you!
This presentation will review how to build a custom maintenance plans from the ground up using TSQL commands.
1. Verify integrity of databases.
2. Backup databases (full versus differential).
3. Backup logs
4. Maintain database indexes.
5. Maintain index/column statistics.
6. Remove older data from [msdb].
7. Remove older backups from file system.
We will be reviewing best practices for daily, weekly and monthly tasks. This includes tape rotation schemes and restoring those backups to make sure they really work.
Biography:
John Miner (craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance.