Chapter 11. SQL Server Agent, Backup, and Restore
Exam objectives in this chapter:
Manage SQL Server Agent.
Configure and maintain a back up strategy.
Restore databases.
Any task you must perform more than a few times is a task that you can automate. Automating tasks minimizes the amount of time you have to spend performing repetitive work and ensures that repetitive tasks are carried out in a consistent manner. SQL Server Agent is the key to automating Microsoft SQL Server administration tasks.
As a database administrator, it is your responsibility to ensure that the databases you are responsible for managing are properly backed up. When developing a data protection strategy, you must understand all the backup options that are available with SQL Server ...
Get Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases 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.
