Practical Maintenance Plans in SQL Server Automation for the DBA /

• Κύριος συγγραφέας: Beard, Bradley (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2016.
• Θέματα: Computer science.; Database management.; Computer Science.; Database Management.

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 resourc...

Πίνακας περιεχομένων:

• 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.