Sql Server 2005 Dba Street Smarts

Hit the ground running with the street-smart training you'll find in this practical book. Using a Year in the life approach, it gives you an inside look at SQL ... » 

Hit the ground running with the street-smart training you'll find in this practical book. Using a Year in the life approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including: Installing and configuring SQL ServerHigh availability and disaster recoveryMaintenance and automationMonitoring and troubleshootingAn Invaluable study tool This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server TM 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including: Upgrading from a previous version of SQL ServerConfiguring an operating modeRestoring a databaseCreating a Transact-SQL user-defined typeUsing Windows System Monitor to Monitor performance «