Showing posts with label publication. Show all posts
Showing posts with label publication. Show all posts

Thursday, March 29, 2012

Cannot remove table from Publication

I am trying to remove a table from a Publication because I want to modify it.
I am going to the Articles tab in the Publication Properties dialog.
However, the checkbox is disabled, probably because the snapshot has run.
How can I modify the table or remove it from the Publication so that it can
be modified?
Environment:
Win2k3
Sql Server 2000
Merge Replication with ce devices
try sp_dropmergearticle
"Thirsh" <Thirsh@.discussions.microsoft.com> wrote in message
news:32274340-B26D-4534-A2F3-FBF6A9B49989@.microsoft.com...
>I am trying to remove a table from a Publication because I want to modify
>it.
> I am going to the Articles tab in the Publication Properties dialog.
> However, the checkbox is disabled, probably because the snapshot has run.
> How can I modify the table or remove it from the Publication so that it
> can
> be modified?
> Environment:
> Win2k3
> Sql Server 2000
> Merge Replication with ce devices
|||I gave it a try. Here's the result from the query analyzer:
Cannot drop article 'AppRoles' from publication 'TB_Tracker' because its
snapshot has been run and this publication could have active subscriptions.
"Hilary Cotter" wrote:

> try sp_dropmergearticle
> "Thirsh" <Thirsh@.discussions.microsoft.com> wrote in message
> news:32274340-B26D-4534-A2F3-FBF6A9B49989@.microsoft.com...
>
>

cannot remove subscription from subscriber!

after deleting a publication from the publisher (which gave a message that
it would also delete all subscriptions to it) the subscription remains on
the subscriber. There is no reference to it on the publisher anymore. It
also looks strange on the subscriber, for example the name format listed in
the subscriptions container on the subscriber was something like
serverName:DatabaseName:PublicationName, and is now only
ServerName:DatabaseName, no publication name. I should also note the name of
the sql server alias used to register it with enterprise manager was change
from that of what it was during the original setup of this replication (was
snapshot, by the way). This was a fix I found for an earlier problem when
trying to setup a new merge replication topology... the alias had to be
changed to match the actual server netbios name. I believe I deleted the
publication from the publisher AFTER I edited the subscriber server's alias
name. Could this have something to do with it?
other info: I cannot delete the tables (articles) from the subscriber
because it thinks its still part of the replication (that was deleted). I
also cannot create the new merge replication, or at least I can create it
but it fails since I need to use the same tables which it thinks are
unavailable due to the previously deleted replication scheme.
any guidance is greatly appreciated. I'm in quite the bind here.
thanks.
answered in the post marked urgent problem
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"djc" <dcopenhaver@.megapathdsl.net> wrote in message
news:%23GZNEuaUEHA.1012@.TK2MSFTNGP09.phx.gbl...
> after deleting a publication from the publisher (which gave a message that
> it would also delete all subscriptions to it) the subscription remains on
> the subscriber. There is no reference to it on the publisher anymore. It
> also looks strange on the subscriber, for example the name format listed
in
> the subscriptions container on the subscriber was something like
> serverName:DatabaseName:PublicationName, and is now only
> ServerName:DatabaseName, no publication name. I should also note the name
of
> the sql server alias used to register it with enterprise manager was
change
> from that of what it was during the original setup of this replication
(was
> snapshot, by the way). This was a fix I found for an earlier problem when
> trying to setup a new merge replication topology... the alias had to be
> changed to match the actual server netbios name. I believe I deleted the
> publication from the publisher AFTER I edited the subscriber server's
alias
> name. Could this have something to do with it?
> other info: I cannot delete the tables (articles) from the subscriber
> because it thinks its still part of the replication (that was deleted). I
> also cannot create the new merge replication, or at least I can create it
> but it fails since I need to use the same tables which it thinks are
> unavailable due to the previously deleted replication scheme.
> any guidance is greatly appreciated. I'm in quite the bind here.
> thanks.
>
|||Running sp_removedbreplication can be used to remove all(ish) traces of
replication in the subscriber database, but obviously must only be done if
this database is not also configured as a publisher. There is also a stored
procedure to tell SQL Server a table is no longer involved in replication
that might be useful: sp_MSunmarkreplinfo which takes the tablename as a
parameter.
Regards,
Paul Ibison
|||thank you! i'll check it out.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uNDdsubUEHA.1764@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> answered in the post marked urgent problem
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "djc" <dcopenhaver@.megapathdsl.net> wrote in message
> news:%23GZNEuaUEHA.1012@.TK2MSFTNGP09.phx.gbl...
that[vbcol=seagreen]
on[vbcol=seagreen]
> in
name[vbcol=seagreen]
> of
> change
> (was
when[vbcol=seagreen]
> alias
I[vbcol=seagreen]
it
>
|||great. thank you.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23TQbhNeUEHA.1012@.TK2MSFTNGP09.phx.gbl...
> Running sp_removedbreplication can be used to remove all(ish) traces of
> replication in the subscriber database, but obviously must only be done if
> this database is not also configured as a publisher. There is also a
stored
> procedure to tell SQL Server a table is no longer involved in replication
> that might be useful: sp_MSunmarkreplinfo which takes the tablename as a
> parameter.
> Regards,
> Paul Ibison
>
sql

Friday, February 10, 2012

Cannot find Snapshot - SQL 2005

Running Win 2003 & SQL 2005 on both machines.
I created a publication on serverA. I subscribed to it on serverB. I
received the error...
Command attempted:
E:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\REPLDATA\unc\unc\R99S-SQLA_DBMOTO_AS400 MASTER
FILES\20061206113840\APVENDP_2.sch
(Transaction sequence number: 0x000049A200000088002A00000000, Command
ID: 16)
Error messages:
The device is not ready.
Thinking that replication was attempting to access the snapshot
locally, I changed to the location of the snapshot in the subscription
to \\serverA\E$\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\REPLDATA\unc\unc\R99S-SQLA_DBMOTO_AS400 MASTER
FILES\20061206113840\APVENDP_2.sch
Note that the location of the snapshot is ....repldata\unc\unc\... in
the error message. I browsed to serverA & there is no
....repldata\unc\unc folder, just a ...repldata\unc folder, then the
folder R99S-SQLA_DBMOTO_AS400 MASTER FILES.
Next I changed the location of the snapshot to reflect where the
subscription was looking ...repldata\unc\unc & now the subscription is
initialized & receiving transactions from the publisher.
With all that said....does anyone know why I had to jump through these
back flips to get replication to work when I did not deviate from the
defaults?
AHIA,
Larry...
It sounds like your default snapshot share location was not specified
correctly. I think it was the double unc which gave you this error message.
I take it this is a pull, if that is the case you don't need to use a UNC.
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
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1165429383.129815.72350@.n67g2000cwd.googlegro ups.com...
> Running Win 2003 & SQL 2005 on both machines.
> I created a publication on serverA. I subscribed to it on serverB. I
> received the error...
> Command attempted:
> E:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\REPLDATA\unc\unc\R99S-SQLA_DBMOTO_AS400 MASTER
> FILES\20061206113840\APVENDP_2.sch
> (Transaction sequence number: 0x000049A200000088002A00000000, Command
> ID: 16)
> Error messages:
> The device is not ready.
> Thinking that replication was attempting to access the snapshot
> locally, I changed to the location of the snapshot in the subscription
> to \\serverA\E$\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\REPLDATA\unc\unc\R99S-SQLA_DBMOTO_AS400 MASTER
> FILES\20061206113840\APVENDP_2.sch
> Note that the location of the snapshot is ....repldata\unc\unc\... in
> the error message. I browsed to serverA & there is no
> ...repldata\unc\unc folder, just a ...repldata\unc folder, then the
> folder R99S-SQLA_DBMOTO_AS400 MASTER FILES.
> Next I changed the location of the snapshot to reflect where the
> subscription was looking ...repldata\unc\unc & now the subscription is
> initialized & receiving transactions from the publisher.
> With all that said....does anyone know why I had to jump through these
> back flips to get replication to work when I did not deviate from the
> defaults?
>
> AHIA,
> Larry...
>
|||Thanks for the response Hilary. How do I fix this? I do not want to
have to do this for every publication/subscription I create.
Larry...
On Dec 6, 12:41 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> It sounds like your default snapshot share location was not specified
> correctly. I think it was the double unc which gave you this error message.
> I take it this is a pull, if that is the case you don't need to use a UNC.
>

Cannot find publication wizard

Hello Guyz

Can any one help me plzz,

Im using sql server 2005 which came with visual studio, and when i wanted to create a publication using sql server management studio. But i could not find the publication folder in the replication folder under my database.

Plzz help me guyz
Its not there. To manage publications in SQL 2005 you need to right click on the publications folder within the replication folder. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 wrote in message news:1663b70d-15b5-4763-90bc-c94f00c3f1b0@.discussions.microsoft.com... Hello Guyz Can any one help me plzz, Im using sql server 2005 which came with visual studio, and when i wanted to create a publication using sql server management studio. But i could not find the publication folder in the replication folder under my database. Plzz help me guyz|||Hi NNTP User,

I did not get u what ur trying to say can u be more clear plzz.
|||The version of sql server which ships with visual studio is called SQL Server Express. This version can only be a subscriber, hence no publication folder. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 wrote in message news:ea624f68-8247-40f4-9423-a00ad3107682@.discussions.microsoft.com... Hi NNTP User, I did not get u what ur trying to say can u be more clear plzz.|||Hi NNTP User,

Thanx for ur help. Can u do me one more small help plz, can u plz send me the link from where i can download sql server which supports publication. thank you once again.
|||

you can download the evaluation edition here. http://www.microsoft.com/sql/downloads/2005/default.mspx