Acquisitions Editor: Agatha Kim
Development Editor: Candace English
Production Editor: Rachel McConlogue
Copy Editor: Judy Flynn
Editorial Manager: Pete Gaughan
Production Manager: Tim Tate
Vice President and Executive Group Publisher: Richard Swadley
Vice President and Publisher: Neil Edde
Book Designer: Maureen Forys
Compositors: Maureen Forys and Craig Woods, Happenstance Type-O-Rama
Proofreader: Publication Services, Inc.
Indexer: Nancy Guenther
Project Coordinator, Cover: Lynsey Stanford
Cover Designer: Ryan Sneed
Cover Image: iStockPhoto
Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN: 978-0-470-49660-2
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, (978) 750-8400,
fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions
Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201)
748-6008, 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 warranties, 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 professional 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 further 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 Customer Care Department within the U.S. at (877) 762-2974, outside the U.S. at (317)
572-3993 or fax (317) 572-4002.
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
Lee, Michael, 1966-
SQL server 2008 administration instant reference / Michael Lee. -- 1st ed.
p. cm.
Summary: “Perfect companion to any SQL Server 2008 book, providing fast, accurate answers on the
spot for millions of IT professionals System and database administrators, IT consultants, and database
application developers often need quick answers and practical solutions for SQL Server issues. This
convenient guide offers you quick referencing for the product and database topics you need most. If
you’re an IT administrator looking for the essentials in the day-to-day tasks of administering SQL
Server 2008, you’ll appreciate this book’s design for providing quick and easy look up of solutions
and tables, lists, and step-by-step instructions for answers on the spot. SQL Server 2008 Instant
Administration Reference is a guide that you want to keep within reach. SQL Server is Microsoft’s
bestselling database manager; the 2008 version offers enhanced security and high availability,
encouraging users to upgrade Features thumb tabs, secondary and tertiary tables of contents, and
special heading treatments to provide quick and easy lookup, as well as quick-reference tables and lists
to provide answers on the spot Covers installing, configuring, managing, and maintaining SQL Server;
optimizing server performance; and troubleshooting SQL Server 2008 Administration Instant Reference
answers the questions you encounter most often in your daily work”—Provided by publisher.
ISBN 978-0-470-49660-2
1. SQL server. 2. Database management. 3. Relational databases. I. Title.
QA76.9.D3L4275 2009
005.75’85--dc22
2009024947
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. Microsoft and SQL Server are registered trademarks 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
96602ffirs.indd 2 7/24/09 8:29:11 AM
