CHAPTER

16

Backup, Recovery, and System Availability

In This Chapter

•   Reasons for Data Loss

•   Introduction to Backup Methods

•   Performing Database Backup

•   Performing Database Recovery

•   System Availability

•   Maintenance Plan Wizard

This chapter first covers two of the most important tasks related to system administration: backup and recovery. Backup refers to the process of making copies of the database(s) and/or transaction logs to separate media that can later be used for recovery, if necessary. Recovery is the process of using the backup media to replace uncommitted, inconsistent, or lost data.

System availability refers to keeping the downtime of the database system as low as possible. This chapter describes in detail ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial