This book combines text, hands-on procedures, and review questions to teach you database administration using SQL Server 2000. It is designed to be completed from the beginning to the end, but you can choose to complete only those sections that interest you. (See the next section, "Finding the Best Starting Point for You," for more information.) If you choose the customized track option, see the "Before You Begin" section in each chapter. Any hands-on procedures that require preliminary work from preceding chapters refer to the appropriate chapters.
This self-paced training book is divided into the following chapters:
- "About This Book" (this chapter) contains a self-paced training overview and introduces the components of this training. Read this section thoroughly to get the greatest educational value from this self-paced training and to plan which lessons you will complete.
- Chapter 1, "Overview of SQL Server 2000," introduces SQL Server 2000. It defines some of the important characteristics of SQL Server 2000 and explains the environments in which it is designed to work. You will be introduced to the different parts of the product and given some idea as to the role played by these parts.
- Chapter 2, "Installing SQL Server 2000," explains how to install SQL Server 2000. It lists the hardware and software requirements of the program, and it explains the specific information you have to supply and the decisions you have to make during the installation process. This chapter covers using default, named, and multiple instances of SQL Server 2000. The chapter also covers performing unattended and remote installations of SQL Server 2000.
- Chapter 3, "Preparing to Use SQL Server 2000," reviews the results of installing SQL Server 2000. This chapter explains starting, stopping, and pausing SQL Server services. The chapter also covers working with OSQL, SQL Query Analyzer, and SQL Server Enterprise Manager.
- Chapter 4, "Upgrading to SQL Server 2000," shows you how to perform a version upgrade of a complete SQL Server 6.5 or 7.0 installation to SQL Server 2000. This chapter also explains how to perform an online database upgrade from SQL Server 7.0.
- Chapter 5, "Understanding System and User Databases," explains SQL Server 2000 databases. This includes the structure of a data file and the architecture of the transaction log. This chapter concludes with a discussion about system tables, including the querying of system and database catalogs.
- Chapter 6, "Creating and Configuring User Databases," teaches how to create a new user database, set database options for new or existing databases, and manage the size of data and transaction log files. This chapter concludes with a discussion about placing database files on multiple disks for recovery, fault tolerance, and performance.
- Chapter 7, "Populating a Database," discusses the population of user databases with existing data. It shows you how to transfer and transform data. This chapter focuses on the use of DTS, Bcp, and the BULK INSERT Transact-SQL statement.
- Chapter 8, "Developing a Data Restoration Strategy," presents an overview of the SQL Server 2000 backup and restore processes and discusses the issues that you should consider when planning a backup and restore strategy for a SQL Server 2000 installation.
- Chapter 9, "Backing Up and Restoring SQL Server," teaches you how to perform database backups using disk and tape. It also teaches you how to perform database restorations. This chapter explains how to use SQL Server Enterprise Manager and Transact-SQL statements.
- Chapter 10, "Managing Access to SQL Server 2000," discusses controlling access to SQL Server 2000, including the authentication process and the authorization process. The chapter concludes by showing you how to create and manage logins.
- Chapter 11, "Managing SQL Server Permissions," shows how to grant database-specific permissions. It also discusses the use of application roles. The chapter concludes by teaching you how to design an access and permissions strategy.
- Chapter 12, "Performing Administrative Tasks," teaches you how to perform a variety of configuration tasks and setup tasks. These include the configuration of the SQL Server service, the SQL Server Agent service, SQL Mail, SQLAgentMail, and XML. The chapter concludes with a discussion of the performance of periodic maintenance tasks.
- Chapter 13, "Automating Administrative Tasks," shows you how to automate routine tasks using operators, jobs, and alerts. It also teaches the creation of a database maintenance plan. It concludes by teaching you to create multiserver jobs.
- Chapter 14, "Monitoring SQL Server Performance and Activity," discusses the development of a performance monitoring methodology. This chapter introduces each of the monitoring tools and shows you how to use each tool. The chapter concludes by teaching you how to perform specific monitoring tasks, such as for memory use or slow-performing queries.
- Chapter 15, "Using SQL Server Replication," introduces planning for, implementing, monitoring, and administering replication. This includes covering the types of replication that are available for automatically replicating data between instances of SQL Server or with heterogeneous data sources.
- Chapter 16, "Maintaining High Availability," discusses the use of standby servers, including the use of log shipping to automate the process of maintaining a standby server. The chapter also discusses the use of SQL Server failover clusters using the Microsoft Cluster Service.
- The Appendix, "Questions and Answers," lists all of the review questions from the book, showing suggested answers.