SQL Server 2000 Advanced DBA Guide

Author: Li Ming
Publisher:
Publish Date: 2003-10-01
Features: This book offers comprehensive content, making it an invaluable resource for both system management beginners and experienced database engineers. Brian shares his extensive knowledge in an easy-to-understand and implementable way. 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 provides detailed information 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.