Author : Jeffrey R. Garbus
Publisher :
Page : 228 pages
File Size : 25,49 MB
Release : 2000
Category : Computers
ISBN : 9781556227479
Book Description
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. Jeffrey Garbus is an experienced SQL Server 7.0 consultant. He has spoken at user conferences, written many magazine articles, and has several SQL and database books to his credit. He is the CEO of Soaring Eagle Consulting, Ltd., based in Florida. Contributing authors: Alvin Chang is a consultant for Soaring Eagle Consulting, and Penny Garbus is president of Soaring Eagle Consulting.