Newb question: how to configure biderectional transactional replication in
sql server 2000
Message posted via http://www.droptable.com
http://support.microsoft.com/default...b;en-us;820675
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jhon via droptable.com" <u6539@.uwe> wrote in message
news:54e46ef6eeff0@.uwe...
> Newb question: how to configure biderectional transactional replication
in
> sql server 2000
>
> --
> Message posted via http://www.droptable.com
|||Thanks, i tried it how ever i got an message while try to enable publishing
and distribution :
"The snapshot folder path , ..................\ReplData uses a special
share name which can usually be accessed only by login with administrative
privelege ... .. . . . .. .. "
what i do wrong, or maybe i miss something
Thank you
Hilary Cotter wrote:[vbcol=seagreen]
>http://support.microsoft.com/default...b;en-us;820675
Message posted via http://www.droptable.com
|||That shouldn't be a problem. Keep going through the wizard accepting
defaults.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jhon via droptable.com" <u6539@.uwe> wrote in message
news:54e4eaf0aadfc@.uwe...
> Thanks, i tried it how ever i got an message while try to enable
> publishing
> and distribution :
> "The snapshot folder path , ..................\ReplData uses a
> special
> share name which can usually be accessed only by login with administrative
> privelege ... .. . . . .. .. "
> what i do wrong, or maybe i miss something
> Thank you
>
> Hilary Cotter wrote:
>
> --
> Message posted via http://www.droptable.com
|||Thanks, Hilary,
So if i understand right i create transactional replication on server1 add
subsciber server2, and
create transactional replication on server2 add subsciber server1.
and that it??
Hilary Cotter wrote:[vbcol=seagreen]
>That shouldn't be a problem. Keep going through the wizard accepting
>defaults.
>[quoted text clipped - 12 lines]
Imagination is more important them knowledge. (A.Einshtein)
Message posted via http://www.droptable.com
|||Yes, that's it. Make sure you follow the kb article to the letter. It is
really important you set the name conflicts section of the table articles
property to keep existing table unchanged.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jhon via droptable.com" <u6539@.uwe> wrote in message
news:54e6217e3e998@.uwe...
> Thanks, Hilary,
> So if i understand right i create transactional replication on server1 add
> subsciber server2, and
> create transactional replication on server2 add subsciber server1.
> and that it??
>
> Hilary Cotter wrote:
> --
> Imagination is more important them knowledge. (A.Einshtein)
>
> Message posted via http://www.droptable.com
Monday, March 12, 2012
how to configure biderectional transactional replication
Labels:
2000message,
biderectional,
configure,
database,
insql,
microsoft,
mysql,
newb,
oracle,
replication,
server,
sql,
transactional,
via
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment