Chapter 14. Administrative Tasks for High Availability

Like the human body, Microsoft SQL Server needs care. When the body gets the right nutrition, sleep, and exercise, it performs at a higher level. If you ignore your body’s needs, you are at a higher risk of developing problems. Proactive administration of your SQL Servers is like daily exercise: your systems will tend to live longer and stay healthier. The topics in this chapter are there for a reason: in most cases they are not about only the administration of one particular technology related to SQL Server. This chapter addresses security, memory, transferring objects, and normal maintenance tasks, such as rebuilding indexes.

Note

Although monitoring is an administrative task, it is covered ...

Get Microsoft® SQL Server™ 2000 High Availability 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.