Part IV: Site Database Maintenance, Recovery, and Upgrade

Part IV covers a wide variety of topics related to the SMS 2003 database. Because the database itself must be maintained on a server running SQL Server 7.0 or 2000, this part approaches database management from two perspectives: management and reporting from within the SMS 2003 Administrator console and maintenance and events related directly to SQL Server. In Chapter 16, 'Queries and Reports,' you'll learn how to query for and report on information kept in the database from within the SMS Administrator Console. In Chapter 17, 'Security,' we'll look at securing access through Windows and through custom consoles, and in Chapter 18, 'Disaster Recovery,' we'll examine disaster recovery techniques. Chapter 19, 'Maintaining the Database Through Microsoft SQL Server,' covers SQL Server topics, including event triggers, SQL Server resources and components used by SMS 2003, maintenance and optimization techniques, and SQL Server backup and restore methods. These chapters aren't intended to be a primer for SQL Server; instead, they're designed to provide the SMS administrator with a basic understanding of SQL Server-related maintenance tasks. Chapter 20, 'Migration Issues,' identifies planning considerations, discusses postmigration issues, and describes client handling and upgrading as well as supporting mixed SMS environments.