O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing automated administration practices

The automation of administrative tasks is essential when the data platform turns to more complex systems and larger databases. The key task for the Database Administrator is to be able to automate the routine tasks and develop proactive maintenance to ensure that data availability and integrity is maintained without any interruption. The life-cycle of automated processes for SQL Server administration is a large topic, and it's not possible to cover all of them in this recipe alone. Hence, the key aspects of automation have been enlisted. In order to accomplish the automated administration, the SQL Server Services must be setup with startup accounts with necessary privileges that will help to harden ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required