Articles in the MS SqlServer Code Category
Administration, MS SqlServer, MS SqlServer Code, Tips Scripts »
These scripts have been created to set up a peer to peer system.
The settings I’ve used:
Login:
PAULSDOMAIN\Administrator
Password:
password
Database name:
peertopeerPublisher
Table with PK:
PITest
Server1
HOME-SERVER
Server2
HOME-SERVER\FIRSTINSTANCE
You’ll need to create an identically named database on 2 servers (called peertopeerPublisher for me) or on a default and a named instance (this is because the publication names must be identical, so we can’t do this on the same instance). After that you’ll need to enable distribution on each server and publishing of the database. This is much the same as before, albeit in a different part of the GUI. There …



