Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover)
by Sujoy Paul (Author)
Link to Amazon
Quick Review:
This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept and methodology at one place.
Detail Review:
Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility. Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending of subsequent updates.
This books talks about different replication types and methods. This book explains different scenarios where types of replication can be used. Sujoy Paul (SQL Server – MCP) explains the concept with many screenshots and simple examples. This book is not limited to replication types only but it also covers replication between heterogeneous databases and other objects.
Pros :
- Lots of screen shots
- Lots of explanation of how different procedures works
- Good coverage of different kind of replications
- Step by Step guidance
- Complete coverage of any methodology
- Truly useful to novice programmers
Cons:
- No discussion about potential errors can come across during replication process
- Some of the screen shots are hard to read (Apress should look into this matter)
- Some of the chapters are very blurry
Overall, this is great book for any novice developer who is beginning in the world of replication. Though this book covers many screenshots and material directly from Book On Line this is great collection of all the concept at any place. I have personally used this book when I was new DBA and have learned replication basics from this book.
Stars: 4 Stars
Summary: This a comprehensive single source of information will save lots of time as there is no need to go through multiple books to implement and maintain replication solutions.
Reference : Pinal Dave (https://blog.sqlauthority.com)
4 Comments. Leave new
Hi,
Need some help regarding SQL server 2005 .
I have set up replication on SQL server 2005 with tables and Clustered and non clustered indexes being replicated.
What i want to know here is what are the important parameters to be monitored and how to set up Notification alerts for the monitoring of these parameters or failures .
Thanks
Pravin
Hi Pinal,
I’m planning to set up a peer-to-peer replication system on SQL server 2008 using windows server 2008.
I’m looking for any kind of benchmark that could help me to determine the expected latency.
Did you seen any kind of benchmark or analysis plan for latency?
the only interesting articles I found was 2005 vs 2008.
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd263442(v=sql.100)
or How can I determine if peer-to-peer can handle the number of transaction my server handle?
Thanks,
Hi Pinal,
i am getting the following error on SQL 2008
The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.
Thanks
Abdul
Hi Pinal waiting for ur reply