Practical Maintenance Plans in SQL Server : Automation for the DBA /
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Formato: | eBook |
| Lenguaje: | English |
| Publicado: |
Berkeley, CA :
Apress : Imprint: Apress,
2016.
|
| Materias: |
Tabla de Contenidos:
- Introduction
- 1. Backing Up a Database
- 2. Checking Database Integrity
- 3. Executing SQL Server Agent Jobs
- 4. Purging Log History
- 5. Clearing Old Backup Files
- 6. Rebuilding Indexes
- 7. Reorganizing Indexes
- 8. Shrinking Database Files
- 9. Updating Object Statistics
- 10. Executing T-SQL Statements
- 11. Notifying Database Operators
- 12. Tying It All Together.