Does anyone know if a 2005 server can replicate data with a 2000 server or
do they all have to be 2005.
Thanks in advance
Martin
Never mind yes it can.
Martin
"Martin McNally" <martinmcnally@.gmail.com> wrote in message
news:%23sZvOazdFHA.3048@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if a 2005 server can replicate data with a 2000 server or
> do they all have to be 2005.
> Thanks in advance
> Martin
>
|||Martin,
there are loads of caveats for this scenario eg logical records, partitions
etc - have a look at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/45154b65-b46f-4aad-82e4-261376a7e9d4.htm
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql
Showing posts with label replicate. Show all posts
Showing posts with label replicate. Show all posts
Wednesday, March 21, 2012
Monday, February 20, 2012
Missing guide
I have a database I wish to replicate, therefore i have set up a
transactional log replication..
But now when I add a row on the main database, this is NOT replicated to
the subscriber...
Then I inizilize a snapshot, (this will drop table and replicate all agian)
the row still do not come over...
What am I doing wrong.. is there a simple guide to how to set it up!!
Please help fast..
MvH
Klaus L Jensen
Ramboll Informatik
By definition this should work. Check to make sure that the log reader agent
is running. If it is, then check to see if the distribution agent is
running.
Also in your distribution database run sp_browsereplcmds to see if you see
this transaction there.
Do you have any filters on your table?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Klaus L Jensen" <NoSpam_News@.Spider_NoSpam.dk> wrote in message
news:%23WkFFuCZEHA.716@.TK2MSFTNGP11.phx.gbl...
> I have a database I wish to replicate, therefore i have set up a
> transactional log replication..
> But now when I add a row on the main database, this is NOT replicated to
> the subscriber...
> Then I inizilize a snapshot, (this will drop table and replicate all
agian)
> the row still do not come over...
> What am I doing wrong.. is there a simple guide to how to set it up!!
> Please help fast..
> MvH
> Klaus L Jensen
> Ramboll Informatik
transactional log replication..
But now when I add a row on the main database, this is NOT replicated to
the subscriber...
Then I inizilize a snapshot, (this will drop table and replicate all agian)
the row still do not come over...
What am I doing wrong.. is there a simple guide to how to set it up!!
Please help fast..
MvH
Klaus L Jensen
Ramboll Informatik
By definition this should work. Check to make sure that the log reader agent
is running. If it is, then check to see if the distribution agent is
running.
Also in your distribution database run sp_browsereplcmds to see if you see
this transaction there.
Do you have any filters on your table?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Klaus L Jensen" <NoSpam_News@.Spider_NoSpam.dk> wrote in message
news:%23WkFFuCZEHA.716@.TK2MSFTNGP11.phx.gbl...
> I have a database I wish to replicate, therefore i have set up a
> transactional log replication..
> But now when I add a row on the main database, this is NOT replicated to
> the subscriber...
> Then I inizilize a snapshot, (this will drop table and replicate all
agian)
> the row still do not come over...
> What am I doing wrong.. is there a simple guide to how to set it up!!
> Please help fast..
> MvH
> Klaus L Jensen
> Ramboll Informatik
Subscribe to:
Posts (Atom)