PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2007 by J.C. Mackin and Mike Hotek
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form
or by any means without the written permission of the publisher.
Library of Congress Control Number 2006932079
Printed and bound in the United States of America.
1 2 3 4 5 6 7 8 9 QWT 1 0 9 8 7 6
Distributed in Canada by H.B. Fenn and Company Ltd.
A CIP catalogue record for this book is available from the British Library.
Microsoft Press books are available through booksellers and distributors worldwide. For further infor-
mation about international editions, contact your local Microsoft Corporation office or contact Microsoft
Press International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress.
Send comments to tkinput@microsoft.com.
Microsoft, Microsoft Press, Active Directory, ActiveX, Excel, MSDN, MSN, Outlook, Visio, Visual
Basic, Visual Studio, Windows, Windows NT, Windows Server, and Windows Vista are either
registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
Other product and company names mentioned herein may be the trademarks of their respective owners.
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places,
and events depicted herein are fictitious. No association with any real company, organization, product,
domain name, e-mail address, logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided
without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its
resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly
or indirectly by this book.
Acquisitions Editor: Ken Jones
Developmental Editor: Karen Szall
Project Editor: Laura Sackerman
Technical Editors: Dan Whalen and Rozanne Murphy Whalen
Copy Editor: Nancy Sixsmith
Body Part No. X12-64010
A04B62173X.fm Page iii Friday, October 13, 2006 11:34 PM
About the Authors
J.C. Mackin
J.C. Mackin (MCSA, MCSE, MCT) is a writer, editor, con-
sultant, and trainer who has been working with Microsoft
networks since 1997. His previous books include MCSA/
MCSE Self-Paced Training Kit (Exam 70-291): Implementing,
Managing, and Maintaining a Microsoft Windows Server 2003
Network Infrastructure. J.C. holds a Master’s degree in Tele-
communications and Network Management.
Mike Hotek
Mike Hotek is a principal of MHS Enterprises, specializing
in database technologies. Mike, an MCITP, has been work-
ing with SQL Server since before it was a Microsoft product
and is known throughout the industry for his expertise in
replication, high availability, disaster recovery, and perfor-
mance tuning. Mike has delivered more than 200 sessions
at a variety of conferences and has coauthored three other
books about Microsoft SQL Server.
A04B62173X.fm Page iv Friday, October 13, 2006 11:34 PM
iv About the Authors
Tobias Thernström
Tobias Thernström, who coauthored the practice test ques-
tions on the companion CD, is a senior database architect
and trainer at RBAM AB, a professional software services
company located in Sweden. Tobias is an MCT and special-
izes in SQL Server. He is the cofounder of the Swedish SQL
Server User Group and a frequent speaker at seminars in
Sweden.
Shannon Horn
Shannon Horn, who coauthored the practice test questions on the companion CD,
has been developing Microsoft Windows and Web-based solutions, training, and
authoring for more than 14 years. He has been a featured speaker at many industry
events, including Microsoft DevDays and the asp.netPRO ASP.NET and Web Ser-
vices Solutions conference. Shannon is a published author on subjects such as
XML, the migration from Visual Basic 6 to VB.NET, JScript.NET, C#, ASP.NET, and
SQL Server 2005.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Contents at a Glance
Planning a Database Server Infrastructure. . . . . . . . . . . . . . . . . . . . . . . . . . 1
Deploying and Consolidating Multiple Instances. . . . . . . . . . . . . . . . . . . 67
Designing SQL Server Security in the Enterprise. . . . . . . . . . . . . . . . . . . . 93
Designing Database Server Security Policies . . . . . . . . . . . . . . . . . . . . . 125
Designing SQL Server Endpoints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169
Designing Database Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197
Planning for High Availability in the Enterprise . . . . . . . . . . . . . . . . . . . 237
Failover Clustering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277
Database Mirroring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313
Log Shipping. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349
Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 383
Designing the Physical Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439
Designing a Data Recovery Strategy. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 529
Archiving Database Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 575
v
评论0