Cover Image
Read Now

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

Full description

Bibliographic Details
Main Author: Beard, Bradley
Format: eBook
Language:English
Published: [New York], New York, NY Apress, Distributed to the Book trade worldwide by Springer Science+Business Media 2016
Series:The expert's voice in SQL server
Subjects:
Client/server Computing / Fast
Bases De Données / Gestion
Architecture Client-serveur (informatique)
Sql Server / Fast
Sql Server / Http://id.loc.gov/authorities/names/n90684343
Database Management / Http://id.loc.gov/authorities/subjects/sh85035848
Client/server Computing / Http://id.loc.gov/authorities/subjects/sh93000502
Database Management / Fast
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Table of Contents:
  • 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

Similar Items