Hi
Can anyone point me in the right direction, I am trying to do an anonymous
pull subscription across the internet. I have created a publisher and created
the snapshot ok. On the subscriber server I can FTP by IP ( the ISA servers
external IP address ) or by the servers name and can see the folders created
in the repldata\ftp directory. I can create a new SQL server registration on
the subscription server and get a connection into the publisher, I can run
sql queries against the publisher ok.
When I try and create a pull subscription, I get to the last page on the
wizard and get
SQL Server enterprise Edition could not create a pull subscription to
publication 'MyDB'
Error 21776: [SQL-DMO] The name 'MyDB' was not found in the TransPublications
collection
Any help greatly appreciated
Having reinstalled and rebooted several times yesterday I was getting nowhere
hence my post in this NG
Come back to it today and the pull subscription worked first time without
any errors on yesterdays configuration. Wierd ?
Anyway, if any one can shed any light on what was going on when it was
failing, please let me know.
thanks
Showing posts with label point. Show all posts
Showing posts with label point. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
Publisher set to Simple Recovery - Is this a problem?
If the publisher database is set on simple recovery mode and if the
transaction log gets truncated on check point, then is there a chance that
the rows that should be replicated might get lost before the log reader agent
can read them and send them to the distributor. Publisher is a 7.0 box and
the distributor/subscriber is a 2000 box.
Adam,
the rows won't be removed unless the log is marked by sp_repldone, so you're
safe.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
transaction log gets truncated on check point, then is there a chance that
the rows that should be replicated might get lost before the log reader agent
can read them and send them to the distributor. Publisher is a 7.0 box and
the distributor/subscriber is a 2000 box.
Adam,
the rows won't be removed unless the log is marked by sp_repldone, so you're
safe.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Posts (Atom)