Chapter 20. Backups
After completing this chapter, you will be able to
Understand the different types of backups.
Perform a full backup.
Perform a differential backup.
Back up a database transaction log.
Restore a database.
Maintenance is a vital task that should be included as part of any database administrator’s (DBA’s) daily workload. Database maintenance includes rebuilding indexes, updating statistics, monitoring performance and security, checking database consistency, and performing database backups. Each task should be done at regular intervals, with the intervals based on the requirements and needs of the organization. Backups are discussed in detail throughout this chapter, while the other tasks are explained later in the book.
Databases can ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
