This is an essential guide to the most common and challenging tasks database administrators will face on the job. It shows readers step by step how to perform various common tasks that they're likely to encounter on the job. It reinforces the objectives mapped out in Microsoft's MCTS exam and demonstrates how to apply them in real-world situations. More than 130,000 people achieved Microsoft's former DBA certification, and the demand for the new MCTS certification for SQL Server 2005 is expected to be strong. It covers topics including installing and configuring, high availability and disaster recovery, supporting data consumers, maintaining databases, and monitoring and troubleshooting