|
| Der Artikel wird am Ende des Bestellprozesses zum Download zur Verfügung gestellt. |
Practical Maintenance Plans in SQL Server
ISBN-13:
9781484218952
Veröffentl:
2016
Seiten:
272
Autor:
Bradley Beard
eBook Typ:
PDF
eBook Format:
EPUB
Kopierschutz:
1 - PDF Watermark
Sprache:
Englisch
Beschreibung:
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 resource - the data you are tasked to manage and safeguard. This book walks even the newest of users through creating a powerful, automated maintenance plan.
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
Kunden Rezensionen
Mehr zum Thema
Folgen Sie uns auf:
