Replication Errors

Hello,
I am getting the following error when trying to sync from my local site to
my dr site.
Could not locate entry in sysdatabases for database '10.1.200.70'. No entry
found with that name. Make sure that the name is entered correctly.
(Source: 10.1.200.70 (Data source); Error number: 911)
I am trying to setup replication from my local site to my DR site. I can
register my dr sql box using the IP but not the hostname.
Any thoughts on this error?
Lontae,
try creating an alias for the server's IP address. You might also need an
entry in the hosts/lmhosts (I can't remember which to locate the snapshot
share.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Alias in DNS?
"Paul Ibison" wrote:

> Lontae,
> try creating an alias for the server's IP address. You might also need an
> entry in the hosts/lmhosts (I can't remember which to locate the snapshot
> share.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Lontae,
alias in the server network utility (I'm sure you now this but if not it's
located at start, programs, microsoft sql server...).
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I think Paul means client network utility
Easy mistake to make, I've made it thousands of times, myself.
For netbios resolution use lmhosts (ie a unc snapshot), for ftp use hosts.
name resolution goes through a sequence so it really doesn't matter as both
files are checked, but there are slight performance increases (milli
seconds) if you make the correct entries.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umx%23oCGvEHA.940@.TK2MSFTNGP14.phx.gbl...
> Lontae,
> alias in the server network utility (I'm sure you now this but if not it's
> located at start, programs, microsoft sql server...).
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Thanks Hilary,
I'm not sure about the setup, but Lontae is registering
the DR site at the local site so I was thinking it was
push rather than pull.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Replication - Row not correctly sync

Hi Everyone!

I have a strange issue in my replicated databases.

I've a 5 merge subscribers replication schema. Our client discover a row that isn't matching with another database.

After some research it seam that the correct row is only at one database and all other database, have a the same row in a incoherent status.

Anyone have a idea on how this could happen?
I'm clue less right now

Thanks!

To fix the issue I decide to bring a change to the correct row to let it propagate to every other subcriber. But event more strange, not all collumn are updated to other subscriber!!!

This is really really strange