I'm trying to get a successful subscription push going on my database
publisher after having to alter a couple of tables. After making my
changes, I tried to start the snapshot agent. Normally, I see the
snapshot being created, which takes a few moments. In this case, all
I saw was the old snapshot, created successfully, which was probably
the one I initially did a month ago. I tried to go ahead and push my
subscription, but the status shows as "Deactivated". My question is,
how do I re-push my subscription to my backup database
machine/database?
You can reinitialize the subscription and then it'll pick up the new
snapshot.
Cheers,
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 snapshot. Show all posts
Showing posts with label snapshot. Show all posts
Tuesday, March 20, 2012
Sunday, March 11, 2012
Cannot create article
What are some things that would stop an article from being created? I am
running a helpfully simple Snapshot Replication on my pc. I am configuring
the SQL Server to do all three roles: Publisher, Distributor and Subscriber.
I am only replicating the Authors table from the Pubs database to a database
called Pubs_Copy.
The error messages is as follows:
SQL Server Enterprise Manager could not create article 'authors' based on
the object 'authors' Error 50007: xp_execresultset: unable to get a bound
connection back to server.
What can check?
You have a remote distributor which you do not have the correct
administrative password for.
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
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:EE5015FD-8630-409A-BC9C-EF91E0480C8A@.microsoft.com...
> What are some things that would stop an article from being created? I am
> running a helpfully simple Snapshot Replication on my pc. I am
configuring
> the SQL Server to do all three roles: Publisher, Distributor and
Subscriber.
> I am only replicating the Authors table from the Pubs database to a
database
> called Pubs_Copy.
> The error messages is as follows:
> SQL Server Enterprise Manager could not create article 'authors' based on
> the object 'authors' Error 50007: xp_execresultset: unable to get a bound
> connection back to server.
> What can check?
running a helpfully simple Snapshot Replication on my pc. I am configuring
the SQL Server to do all three roles: Publisher, Distributor and Subscriber.
I am only replicating the Authors table from the Pubs database to a database
called Pubs_Copy.
The error messages is as follows:
SQL Server Enterprise Manager could not create article 'authors' based on
the object 'authors' Error 50007: xp_execresultset: unable to get a bound
connection back to server.
What can check?
You have a remote distributor which you do not have the correct
administrative password for.
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
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:EE5015FD-8630-409A-BC9C-EF91E0480C8A@.microsoft.com...
> What are some things that would stop an article from being created? I am
> running a helpfully simple Snapshot Replication on my pc. I am
configuring
> the SQL Server to do all three roles: Publisher, Distributor and
Subscriber.
> I am only replicating the Authors table from the Pubs database to a
database
> called Pubs_Copy.
> The error messages is as follows:
> SQL Server Enterprise Manager could not create article 'authors' based on
> the object 'authors' Error 50007: xp_execresultset: unable to get a bound
> connection back to server.
> What can check?
Subscribe to:
Posts (Atom)