SQL Server 2000 Advanced DBA Guide

Author: Light
Publisher:
Publish Date: 2003-10-01
Features: This book is comprehensive, serving as an invaluable resource for both system management novices and experienced database engineers. Brian shares his extensive knowledge in an easy-to-understand and implementable manner. The book provides previously undisclosed management and troubleshooting techniques that you can use to configure and manage SQL Server 2000 for optimal performance and high availability. SQL Server expert Brian Knight offers detailed insights on system and platform architecture, setup, security, file management, replication, automation, backup, clustering, and recovery in the book. He also elaborates on the following three aspects: how to maximize the use of built-in management tools, how to create maintenance plans to prevent downtime caused by failures, and how to holistically optimize system performance. As a concise and practical reference book, it will save you a significant amount of troubleshooting time.