this print for content only—size & color not accurate spine = 1.773" 936 page count
Books for professionals By professionals
®
Pro SQL Server 2008 Replication
Dear Reader:
Replication facilitates the transfer of data and objects from one database to
another across different platforms and geographic locales. The physical separa-
tion of databases and the inherent latency associated with replication makes it an
attractive technology in various business implementations. However, configuring,
administering, and optimizing a harmonious replication environment can be
a daunting task even for the seasoned DBA due to the complexities of not only
maintaining data integrity, but also knowing how the innards of replication work.
This book explains the different types of replication available in SQL Server
2008 and provides realistic examples of how those types can be deployed.
In this book I discuss the configuration and administration of snapshot, trans-
actional, peer-to-peer, merge, and heterogeneous replication. You’ll see how
to work with configuration from both a GUI and a command-line perspective.
Besides discussing the internals of different types of replication, I also dem-
onstrate the new features, such as the filestream feature in merge replication.
You’ll learn about bidirectional, transactional replication. And you’ll learn to
configure replication through SQLCMD, using it, for example, to configure log
shipping with replication.
Other tools such as the tablediff utility, the Database Engine Tuning Advisor,
and Replication Monitor are covered, with emphasis upon their use in backing
up, recovering, and optimizing replication environments. Management Data
Warehouse, which is new in SQL Server 2008, is an exciting technology that can
help you monitor replication performance. You’ll find examples of how to use
the Management Data Warehouse in this book.
I hope you find this book rewarding and as pleasurable to read as it was to
write. I am grateful for the opportunity to teach you what I know on a topic I am
passionate about.
Sujoy P. Paul, MCP
Author of
Pro SQL Server 2005
Replication
Shelve in
Programming
User level:
Intermediate–Advanced
Paul
SQL Server 2008
Replication
The eXperT’s Voice
®
in sQl serVer
Pro
SQL Server 2008
Replication
cyan
MaGenTa
yelloW
Black
panTone 123 c
Sujoy P. Paul
Companion eBook Available
THE APRESS ROADMAP
Pro T-SQL 2008
Programmer’s Guide
Pro SQL Server
Disaster Recovery
Pro SQL Server 2008
Replication
Accelerated
SQL Server 2008
SQL Server 2008
Query Performance
Tuning Distilled
www.apress.com
SOURCE CODE ONLINE
Companion eBook
See last page for details
on $10 eBook version
An essential and comprehensive guide to
developing, administering, and mastering the
complexities of SQL Server 2008 replication
ISBN 978-1-4302-1807-4
9 781430 218074
9 0 0 0 0
Pro
剩余937页未读，继续阅读
评论0
最新资源