SQL Server 2008 Administration

819 Pages·2010·16.44 MB·English

by  Tom Carpenter

Carpenter
Take Your Career to the Next Level
Microsoft®
S M
with This Practical Reference icr SQL Server 2008
Q o
s ®
o
f
L t®

Database expert Tom Carpenter gives you the information you need to not only prepare for the MCTS and S
MCITP certifi cation exams for SQL Server 2008 Database Administration, but also to excel in your job. From Administration
e
planning to disaster recovery to security best practices, this reference explores the real-world tasks and scenarios
r
you’ll face as an SQL Server 2008 Database Administrator and shows you step by step how to handle them.
v
e
• Install and confi gure SQL Server 2008
r
• Implement, maintain, and repair the SQL Server database
Covers the exam ®
• Utilize indexes and views to get a better understanding of your data
objectives for the 2
• Monitor and tune your database for optimal performance
following Microsoft 0
• Keep your data safe from threats and vulnerabilities SQL Server 2008
0
• Achieve high availability by clustering your servers Administration Exams: Real-World Skills for MCITP Certification and Beyond
8
• Prepare for MCTS and MCITP SQL Server 2008 Database Administration
MCTS: SQL Server

certifi cation 2008, Installation and A
Maintenance (Exam
d
FEATURED ON THE CD 70-432)
m
MCITP: Designing,
VIDEO DEMONSTRATIONS
Optimizing and i
See video walk-throughs for some of the more challenging tasks you’ll face n
Maintaining a SQL
on the job. i
Server 2008 Database s
PRACTICE EXAMS Server Infrastructure
t
Test your knowledge with practice exams that help you prepare for certifi cation. (Exam 70-450) r
a
ELECTRONIC FLASHCARDS
t
Take advantage of electronic fl ashcards to reinforce your understanding of key concepts. i
o
n
ABOUT THE AUTHOR

Tom Carpenter, MCTS: SQL Server 2005, MCITP: SQL Server 2005, is the founder of and Senior Consultant
for The Systems Education and Consulting Company (SysEdCo), a training and consulting fi rm located Real-World Skills for
in central Ohio. He is the author of several books on technical topics, including networking infrastructure, MCITP Certifi cation
and Beyond
database management, and VoIP.
ISBN 978-0-470-55420-3
$69.99 USA Tom Carpenter
Exams 70-432 and 70-450
$83.99 CAN
www.sybex.com/go/sqlserver08admin
SERIOUS SKILLS.
COMPUTERS / Certifi cation Guides
554203ffirs.indd 2 4/13/10 9:27:48 AM
SQL Server® 2008
Administration
554203ffirs.indd 1 4/13/10 9:27:47 AM
554203ffirs.indd 2 4/13/10 9:27:48 AM
SQL Server® 2008
Administration
Real World Skills for
MCITP Certification and Beyond
Tom Carpenter
554203ffirs.indd 3 4/13/10 9:27:48 AM
Acquisitions Editor: Jeff Kellum
Development Editor: Denise Santoro Lincoln
Technical Editors: Acey Bunch and Mitchel Sellers
Production Editor: Elizabeth Ginns Britten
Copy Editor: Kathy Grider-Carlyle
Editorial Manager: Pete Gaughan
Production Manager: Tim Tate
Vice President and Executive Group Publisher: Richard Swadley
Vice President and Publisher: Neil Edde
Media Project Manager 1: Laura Moss-Hollister
Media Associate Producer: Josh Frank
Media Quality Assurance: Shawn Patrick
Book Designers: Judy Fung, Bill Gibson
Compositor: Craig Johnson, Happenstance Type-O-Rama
Proofreader: Word One, New York
Indexer: Ted Laux
Project Coordinator, Cover: Lynsey Stanford
Cover Designer: Ryan Sneed
Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN: 978-0-470-55420-3
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any
means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Sections
107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or
authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood
Drive, Danvers, MA 01923, [phone], fax [phone]. Requests to the Publisher for permission should
be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030,
[phone], fax [phone], or online at http://www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties
with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warran-
ties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or
extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for
every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal,
accounting, or other professional services. If professional assistance is required, the services of a competent profes-
sional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom.
The fact that an organization or Web site is referred to in this work as a citation and/or a potential source of fur-
ther information does not mean that the author or the publisher endorses the information the organization or Web
site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed
in this work may have changed or disappeared between when this work was written and when it is read.
For general information on our other products and services or to obtain technical support, please contact our Cus-
tomer Care Department within the U.S. at [phone], outside the U.S. at [phone], or fax [phone].
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be
available in electronic books.
Library of Congress Cataloging-in-Publication Data
Carpenter, Tom.
SQL server 2008 administration : real world skills for MCITP certification and beyond / Tom Carpenter.—1st ed.
p. cm.
Includes bibliographical references and index.
ISBN 978-0-470-55420-3 (papen/cd-rom : alk. paper)
978-0-470-6494-4 (ebk); 978-0-470-6494-8 (ebk); 978-0-470-6494-1 (ebk)
1. Electronic data processing personnel—Certification. 2. Microsoft software—Examinations—Study guides.
3. SQL server. I. Title.
QA76.3.C34845 2010
005.4’476—dc22
2010004720
TRADEMARKS: Wiley, the Wiley logo, and the Sybex logo are trademarks or registered trademarks of John
Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without
written permission. SQL Server is a registered trademark of Microsoft Corporation in the United States and/or
other countries. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not
associated with any product or vendor mentioned in this book.
10 9 8 7 6 5 4 3 2 1
554203ffirs.indd 4 4/13/10 9:27:48 AM
Dear Reader,
Thank you for choosing SQL Server 2008 Administration: Real World Skills for MCITP
Certification and Beyond. This book is part of a family of premium-quality Sybex books,
all of which are written by outstanding authors who combine practical experience with a
gift for teaching.
Sybex was founded in 1976. More than 30 years later, we’re still committed to producing
consistently exceptional books. With each of our titles, we’re working hard to set a new
standard for the industry. From the paper we print on to the authors we work with, our
goal is to bring you the best books available.
I hope you see all of that reflected in these pages. I’d be very interested to hear your com-
ments and get your feedback on how we’re doing. Feel free to let me know what you think
about this or any other Sybex book by sending me an email at [email protected]. If you
think you’ve found a technical error in this book, please visit http://sybex.custhelp.com.
Customer feedback is critical to our efforts at Sybex.
Best regards,

Neil Edde
Vice President and Publisher
Sybex, an Imprint of Wiley
554203ffirs.indd 5 4/13/10 9:27:48 AM
I dedicate this book to my family and God—the two most important
relationships in my life. Thanks for all you do.
554203ffirs.indd 6 4/13/10 9:27:48 AM
Acknowledgments
I would like to acknowledge the members of my amazing family, who continue to find
the energy to support me during long writing projects. Tracy, I love you and appreciate the
unending patience you’ve shown during the writing process. Faith, Rachel, Thomas, and
Sarah, you are the most amazing children any father could hope to lead. I would also like to
thank Denise Santoro Lincoln, one of the most proficient editors I’ve had the chance to work
with. She is certain to make any book she touches better. Additionally, I’d like to thank Jeff
Kellum for allowing me to write my first Sybex book. I’ve been an admirer of Sybex books for
many years and am proud to have my name on the cover of one. Of course, I must acknowl-
edge all of my training attendees and consulting clients. They have provided me with the
greater depth of knowledge required to write a book like this.
554203ffirs.indd 7 4/13/10 9:27:49 AM
About the Author
Tom Carpenter is a consultant and trainer based in Marysville, Ohio. He is the founder and
current Senior Consultant for The Systems Education and Consulting Company (SysEdCo).
SysEdCo provides training on Microsoft technologies, wireless networking, security, and IT
professional development. Tom is the author of several books on topics ranging from wireless
network administration to SQL Server database administration and optimization. Tom holds
several certifications including MCITP: SQL Server 2008 Database Administrator, CWNA,
CWSP, Project+, and several additional Microsoft certifications. He spends every spare
moment he can with his amazing wife and children.
554203ffirs.indd 8 4/13/10 9:27:49 AM