Learn SQL Server 7.0 Administration

Systems administrators often have two basic questions:
What do I need to do to keep the system running smoothly?
What do I do if something goes wrong?

Learn SQL Server 7.0 Administration answers the first question in detail, with the expectation that this will prevent the second question from being asked.

To achieve this goal, SQL Server consultant Jeffrey Garbus provides detailed information about designing and implementing a preventive maintenance regimen in order to ensure ongoing reliability, performance, and preparedness for disaster recovery. The book opens by introducing basic concepts, then quickly progresses to such advanced topics as configuring SQL Server for optimum performance, monitoring activity on the server, using the Database Consistency Checker, and backing up and restoring the database. Updating index statistics, using wizards to automate tasks, and replicating data are also covered.

Garbus’ book is for anyone who must learn to maintain a SQL Server.