2012. 2. 6. 09:48
Brain Trainning/DataBase
리플리케이션을 하다 보면 의외로 관련된 책 및 자료가 부족할때가 있습니다.
하나씩 필요한 글을 정리해서 저장해 둬야겠네요. 다음 글들은 많은 도움이 됩니다. 기초부터 이런 저런 것들까지
하나씩 필요한 글을 정리해서 저장해 둬야겠네요. 다음 글들은 많은 도움이 됩니다. 기초부터 이런 저런 것들까지
Scaling Out the Distribution Database (2010/03/30)
http://www.sqlservercentral.com/articles/Replication/69663/SQL Replication can solve many problems in running database-driven applications. The publication/subscriber model isn't completely easy to understand, the complexities of scripting and monitoring replication systems takes some thought. Here, at last, is a series of articles that takes care to produce a jargon-free approach to SQL Server Replication of all types.
Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication
In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored. Read more...
By Sebastian Meine | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication: Level 2 - The Role of the Distributor
In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored. Read more...
By Sebastian Meine | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication: Level 3 - Transactional Replication – The Publisher
The Publisher is the database where all replicated data originates. Each Publisher can have multiple publications defined within it. Each publication contains a set of articles that all need to reside in a single database. Each article corresponds to all or part of a single database object. A single database object can map to an article in more than one publication. Read more...
By Sebastian Meine | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication: Level 4 - Transactional Replication – The Subscriber
The Subscriber is the server where all the changes that are published by replication get delivered to. Every publication needs to have at least one subscriber, but a publication can have many subscribers. This level assumes that you have followed the first three levels and that you have a publication set up, to which you can subscribe. Read more...
By Sebastian Meine | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication - Level 5: Transactional Replication & How it works
This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored. Read more...
By Sebastian Meine 2011/07/20 | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication - Level 6: Merge Replication - Publication
This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored. Read more...
By Sebastian Meine 2012/01/13 | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication - Level 7: Merge Replication – Subscription
This level of the Stairway will cover the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored. Read more...
By Sebastian Meine 2012/02/03 | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication - Level 8: Merge Replication – How it works
How merge replication works, including the impact on the published database. The merge agent, different conflict situations and their resolutions are introduced. Read more...
By Sebastian Meine 2012/03/02 | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication - Level 9: The Replication Monitor
Introducing the replication monitor and how to use it to monitor replication health. It also introduces tracer tokens. Read more...
By Sebastian Meine 2012/03/21 | Source: SQLServerCentral.com | Category: stairway series
Stairway to SQL Server Replication - Level 10: Troubleshooting
The final level of this Stairway takes you through how to identify and fix common errors. Read more...
By Sebastian Meine 2012/04/11 | Source: SQLServerCentral.com | Category: stairway series
'Brain Trainning > DataBase' 카테고리의 다른 글
[MSSQL] DMV - sp_who2 Version (0) | 2012.02.07 |
---|---|
[MSSQL] SQL Server Load Generator (0) | 2012.02.07 |
[MSSQL] DBCC Trace Flag 정리 (0) | 2012.02.05 |
[MSSQL] Replication 복제 오류 (0) | 2012.02.05 |
[MSSQL] Microsoft iSCSI Software Target 사용하기 (0) | 2012.02.02 |