Replication

  • What are the best pratices for setting up replication environment.

  • This was removed by the editor as SPAM

  • Wish I had all the answers. I'd say one is to test a lot, set up and tear down, before putting into production. When it breaks, you want to know what goes where. Replicate the least amount of data you need, use the lightest form of replication you can, avoid filtering if you can. Hard to determine up front, but look at whether you need to put distribution db on a different server, and/or run the agents on the client instead of the distributor or publisher.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • quote:


    What are the best pratices for setting up replication environment.


    Be sure to read the replication primer from Mike Hotek. THe site is mentioned below. He is coming out with a book sometime this year devoted to replication only

    http://www.mssqlserver.com/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply