Chapter 11. SQL Server Agent, Backup, and Restore
Exam objectives in this chapter:
Manage SQL Server Agent.
Configure and maintain a back up strategy.
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 ...