Chargement en cours…
Practical Maintenance Plans in SQL Server Automation for the DBA /
This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that's it, but there is so much more that can and must be done to ensure the integrity of your most important company re...
| Cote: | Libro Electrónico |
|---|---|
| Auteur principal: | |
| Collectivité auteur: | |
| Format: | Électronique eBook |
| Langue: | Inglés |
| Publié: |
Berkeley, CA :
Apress : Imprint: Apress,
2016.
|
| Édition: | 1st ed. 2016. |
| Sujets: | |
| Accès en ligne: | Texto Completo |
Table des matières:
- 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.