asked on

Does MSSQL Peer-to-Peer - Transactional Replication leverage Sites and Services topology>

I am looking to give my remote offices a better experience with one of our primary applications that sites on top of a MSSQL 2005 Server. If I setup a Peer to Peer transactional replication will users in Site A talk to Site A Peer server and Site B users talk to it's Site Peer?

Vitor Montalvão

That only depends to which server they are configured to connect to.

yo_bee

ASKER

Ok , so this is not dynamic?

Vitor Montalvão

What do you mean with dynamic?
Or you connect to one server or to another one.

yo_bee

ASKER

With Active Directory and Sites & Services I can control how locations access resources.
If I have a file server with DFS (Distributed File System) and I configured my Sites & Services for one subnet to first look to see if the DFS server is avail bale in the location it will access the files locally, but if it is not available it will try another server in another location.

I was wondering if PEER to PEER setup will take advantage of this?

Vitor Montalvão

What that has to have with SQL Server?

yo_bee

ASKER

I was thinking that PEER to PEER would give local access to the DB with little to configure.

If I have an application that runs on top of a MSSQL DB and I set up P2P Trans log replication I want the application to talk to the nearest MSSQL server. How would I accomplish this?

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

yo_bee

ASKER

Thank you.

I will be doing some testing with what you suggested.

Does MSSQL Peer-to-Peer - Transactional Replication leverage Sites and Services topology&gt;

Does MSSQL Peer-to-Peer - Transactional Replication leverage Sites and Services topology>