SQL Server Replication

Welcome to www.ReplicationAnswers.com - a community resource for SQL Server DBAs who are interested in learning more about SQL Server replication....Please send any comments about articles etc to Paul.Ibison@ReplicationAnswers.Com.

When you have a sec please check out this book for a decent addition to your SQL bookshelf.

There's loads of interesting content including a Jason Bourne level of excitement chapter (36) on a few undocumented replication techniques by yours truly :). Finally, and importantly, it's a collaborative effort by 53 (MVP) authors who have each donated 100% of their royalties to War Child International.

Consultancy....I'm getting a lot of emails asking for advice and help with replication. Sometimes this is from big firms (most recently the Royal Bank of Scotland) and sometimes small firms (a local veterinary practice!). Doesn't matter to me - I like all this sort of work! Please refer to the separate page if this might be of interest to you. Also, mostly this is done remotely so where you are isn't an issue.

Below is a list of the most recent additions to the site.

Can I use cascading FK changes with transactional replication?	22nd Dec 2011	Transactional
Implementing NoSync Initializations (and variations) on SQL Server 2005/8 - UPDATED	17th Oct 2011	Articles
Peer-to-Peer Transactional Replication: Solving Conflicts and Errors	12th May 2011	Articles
Peer-to-Peer Transactional Replication: How Conflict Detection Works	12th May 2011	Articles
When initializing I get this error - why? The process could not bulk copy into table '"dbo"."xyz"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037) Get help: http://help/MSSQL_REPL20037 Field size too large (Source: MSSQLServer, Error number: 0)	12th May 2011	Merge
Question - what does this setting do in Snapshot replication?	11th April 2011	General