Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 is it possible to replicate on the same server?

Author  Topic 

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-02-25 : 05:47:07
I tried to practice replication on my server and can't seem to get the allow peer-to-peer properties on the publication.

any ideas would be great...

thanks in advance

--------------------
keeping it simple...

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-25 : 14:30:54
if it's peer to peer, you need to have at least 2 instances of sql installed.

yes, it will work on same machine, we do this in our dev environment
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-02-27 : 09:19:40
Thanks for the reply Russel, I tried it out yesterday. Now, trying mirroring, just tried out logshipping...and tomorrow, combinations...



quote:
Originally posted by russell

if it's peer to peer, you need to have at least 2 instances of sql installed.

yes, it will work on same machine, we do this in our dev environment



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -