Can I read Practical Maintenance Plans in SQL Server : Automation for the DBA on EtoBox?

Practical Maintenance Plans in SQL Server : Automation for the DBA by Bradley Beard; SpringerLink (Online service) is a nonfiction available to read on EtoBox.

What is Practical Maintenance Plans in SQL Server : Automation for the DBA about?

Contents at a Glance 6 Contents 8 About the Author 14 About the Technical Reviewer 16 Acknowledgments 18 Introduction 20 Chapter 1: Introduction to Maintenance Plans 22 Before We Start 22 What Is a Maintenance Plan? 23 Maintenance Plan Wizard Task Options 24 Maintenance Plan Design Surface Options 25 Summary 27 Chapter 2: Backing Up a Database 28 Recovery Models 28 Full 30 Bulk Logged 30 Simple 30 Backup Types 30 Full Backups 31 Differential Backups 31 Transaction Log Backups 31 Setting Up the Maintenance Plan 33 Full Backup Configuration 33 Differential Backup Configuration 39 Transaction Log Backup Configuration 42 Configuring the Jobs 46 Summary 52 Chapter 3: Checking Database Integrity 53 What Is Database Integrity? 53 Practical Application of Database Integrity Principles 54 Setting Up the Maintenance Plan 56 Summary 63 Chapter 4: Executing SQL Server Agent Jobs 64 E-mail from the Database 64 Configuring E-mail 65 Sending a Test E-mail 75 Enabling the Mail Profile 76 SQL Agent Job Creation 78 Creating an Example Table 79 Writing a Query for the Job 79 Creating a SQL Agent Job 80 SQL Server Agent Options 81 Notifications 82 Targets 82 Steps Tab 82 General 82 Advanced 84 Schedul

Who reads Practical Maintenance Plans in SQL Server : Automation for the DBA?

Author

Bradley Beard; SpringerLink (Online service)

Publisher

Apress : Imprint : Apress

Published

2016

Language

EN

ISBN

9781484218952

Category

nonfiction

Subjects

Management, Computer Science, Databases