This is a survival guide and easy reference for every SQL Server 2000 database administrator, covering every key task associated with installation and day-to-day administration. With thousands of installations worldwide, Microsoft SQL Server 2000 is an industry-leading solution for highly scalable, fast, and reliable database management. This hands-on guide covers the installation, configuration, and administration of SQL Server while providing practical solutions to the daily challenges faced by busy administrators. Filled with real-world examples, ' Essential SQL Server 2000: An Administration Handbook ' is a succinct survival guide for both experienced professionals as well as those less familiar with the environment. Whether you are a programmer who takes on database administration or a database administrator who is new to SQL Server 2000, you will find this guide an indispensable resource. The book begins with a review of database basics, then progresses to everyday topics including installation, tools, data access, import/export, commands, automation, maintenance, and tuning. The final chapters cover the more advanced features of SQL Server and provide a sample server sizing exercise and helpful hardware discussion. Chapters are organized to provide easy look-up for solving specific problems, while cover-to-cover, the book provides a complete primer on SQL Server essentials. Topics covered include: Database basics, and the features and flavors of SQL Server 2000 Installation and tips for upgrading from previous versions Data access and connection methods for SQL Server Importing and exporting data Automating SQL Server and operating system commands Strategies for successful database maintenance Backing up and restoring SQL databases Security aspects of SQL Server Introduction to Microsoft Analysis Services with working examples Overview of the XML technology in SQL Server Packed with practical tips and timesaving solutions, 'Essential SQL Server 2000: An Administration Handbook' is a must-have guide for every administrator managing the day-to-day SQL Server environment. 0201742039B11282001 '