Chapter 10. Automating and Maintaining SQL Server 2012

Automation and maintenance go hand in hand. You can automate many routine database administration tasks, most of which have to do with maintenance issues such as backing up databases or running consistency checks. Automation allows you to increase productivity, complete tasks while away from your computer, and more. You can configure the server to monitor processes and user activities, to check for errors, and to alert you when related events occur. If you configure alerts ...

Get Microsoft® SQL Server® 2012: Pocket Consultant 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.