Chapter 3Maintenance and Automation
After you have installed and configured a server, even before you let the first user on it, you need to create a maintenance plan. Maintenance includes more than just backups and defragmenting a system—it includes audits and checking the system for operational status. In the first part of this chapter, I explain what you need to understand about maintenance and the audits and other documentation you need to create.
In the second half of this chapter, I explain how automation works in SQL Server 2005. Automation is getting the computer to do what it does best: repetitive tasks. Although you will use automation in lots of places, the first logical application is in automating the maintenance your system needs. ...
Get Administrator’s Guide to SQL Server 2005 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.
