dropping replication

Hi,
Is there any way to drop a single replication. one subscriber server was taken down without dropping first. Now I have a pull at publisher which is in state of reinitialized and waiting for the server to be back on.
I don not want to drop all replication and create them again. So I wonder if there is anyway to just drop that single replication belong to the taken off server.

Thanks for the help in advance.Yes, just execute 'sp_dropsubscription' with the correct parameters in the publication.

Just for future references, the pull subscription should be dropped in the subscriber before you take the server down.|||ty.
Edit:
according to BOL.
sp_dropsubscription is used in snapshot and transactional replication.
but this is merge.|||Did you mention it was a Merge?|||yup it is merge replication. I am sorry I didn't mention on first msg.

Droping a table in subscrier !

Hello,
I had a merge replication that was replicating a table, and i deleted it,
now it doesn't let me drop that replicated table in my subscriber database.
It says that it is being used for replication.
I even stoped and started my server, but no success.
Any help !!!!!!!!
Thanks,
Mathew
Matthew,
have a look at using sp_MSunmarkreplinfo.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

drop subscriptions

Hi all,
How can I remove a list of subscriptions from the server?
My server acts as PUBLISHER and SUBSCRIBER at the same time, but both
features has been disabled. So, I can't delete the subscriptions list
because I have no PUBLISHER and SUBSCRIBER now.
I've tryied with differents commands like sp_dropsubscriptions,
sp_dropsubscriber, etc, but nothing works.
Is there any way to drop all this trash?
thanks.
Can you enable the databases for publishing and then remove them?
If there are no live subscriptions you can merely delete the contents of
MSreplication_subscriptions and MSsubscription_agents if you have
transactional replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"JG Espinoza" <jasiele@.NOSPAMhotmail.com> wrote in message
news:ePyf4TS%23EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> How can I remove a list of subscriptions from the server?
>
> My server acts as PUBLISHER and SUBSCRIBER at the same time, but both
> features has been disabled. So, I can't delete the subscriptions list
> because I have no PUBLISHER and SUBSCRIBER now.
>
> I've tryied with differents commands like sp_dropsubscriptions,
> sp_dropsubscriber, etc, but nothing works.
>
> Is there any way to drop all this trash?
>
> thanks.
>
|||I can enable the database but i can't delete it as well.
How can I delete the content of MSreplication_subscriptions and
MSsubscription_agents?
I have both transactional and merge subscriptions.
Thanks for your help.
"Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
news:exdnkkS%23EHA.1076@.TK2MSFTNGP10.phx.gbl...
> Can you enable the databases for publishing and then remove them?
> If there are no live subscriptions you can merely delete the contents of
> MSreplication_subscriptions and MSsubscription_agents if you have
> transactional replication.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "JG Espinoza" <jasiele@.NOSPAMhotmail.com> wrote in message
> news:ePyf4TS%23EHA.3616@.TK2MSFTNGP11.phx.gbl...
>
|||As the databases aren't used for publications or
subscriptions, you could use sp_removedbreplication.
Regards,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||My above answer about enabling and disabling the databases for publication
was a bad one.
For transactional all you have to do is
delete from MSreplication_subscriptions
or
delete from MSsubscription_agents
To get rid of merge publication metadata use this script
http://groups-beta.google.com/group/...4?dmode=source
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"JG Espinoza" <jasiele@.NOSPAMhotmail.com> wrote in message
news:%23$xWFoS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> I can enable the database but i can't delete it as well.
>
> How can I delete the content of MSreplication_subscriptions and
> MSsubscription_agents?
>
> I have both transactional and merge subscriptions.
>
>
> Thanks for your help.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
> news:exdnkkS%23EHA.1076@.TK2MSFTNGP10.phx.gbl...
>

drop subscription

is there anyone know how to drop subscription from the publisher database without a connection to the subscriber(because the subscriber server is formated)You can certainly do this using the replication stored procedures, but the GUI can't do it for you. You'll need to get someone that understands both SQL Server replication and your environment in order to do this safely. Microsoft Professional Support Services will help you work through this for a fee.

Another alternative is to backup the database, drop the database, then restore the backup. This is simple and except for the down time relatively painless.

-PatP|||actually the backup, drop and restore solution is the easiest way but you can do that in a test environment but I have a live environment of 50 subscribers and if I want to create a snapshots for these subscribers it'll take a lot of time thats for coping a bout 800MB at least throw a WAN network
However, you can drop the publications and rebuild them on the publisher database.
You cay find the sp_dropsubscriptions but it's not working good
I'm trying to reach someone can drop the subscription for one subscriber only without dropping all publication|||I can do it, and I'm sure that some of the folks here on DBForums can do it, but I don't know any simple way to describe how to do it. You really need to understand how SQL Replication works, and how your particular setup is configured.

I'm sorry, but I don't know of a simple solution to your problem.

The cheapest answer long term is likely to be to call MS-PSS and ask them to walk you through the process. It will cost you some money, but only a tiny fraction of what rebuilding whole databases might cost.

-PatP

Drop Subcription at subscriber

Sql Server 2000. I had a merge publication setup on one table that replicated to several sql servers (all 2000 SP3). The publication was deleted on the publisher - but somehow - the subscription information is still on the subscribers. How can I remove them? When trying to delete the tables at the subscribers I get error that they are part of replication.

P.S. Other tables in the same database are part of different merge replication.

Thanks.

Abe

If you do not want the subscriber database to be participated in replication, you can do

sp_replicationdboption 'subscriber_database', 'subscribe', 'false' on the subscriber side; then drop the table.

Thanks.

This posting is provided AS IS with no warranties, and confers no rights

|||Thank you for your reply. I forgot to mention in the original post (which i justed edited) that the database contains tables (not the table I'm trying to delete) that are part of another publication. Therefore I do not think I can run sp_replicationdboption. Also, I thought you can only run sp_replicationdboption on the publisher - but I stand to be corrected.|||Run sp_dropmergepullsubscription with required parameters at the subscriber database.

drop manually table (on the subscriber) that was part of merge p

Hi ,
I am trying to drop manually table (on the subscriber) that was part of
merge publication before but got the below message. The publication was
dropped using E.M and even when try to re-create merge publication and add
this table it failed due to the fact that the it can not drop the specific
table on the subscriber .
Can I find any system store proc that force drop this table? Can I drop
it manually from system table (what tables )?
The message is :
Cannot drop the table 'XXXX' because it is being used for replication.
There is a stored procedure to do this called sp_MSunmarkreplinfo which
takes a tablename as a parameter. Alternatively, setting replinfo to 0 in
sysobjects for the particular table should do it. Finally, running
sp_removedbreplication can be used to remove all traces of replication in
the subscriber database, but obviously must only be done if this database is
not also configured as a publisher.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Drop database problem

Hi All,

I use SQL SERVER 2005 and SQL SERVER Mobile.

My SQL Server I created publication, and on mobile subscriber and did web Synchronization , no problem.

I deleted publication from under Local Publication with SQL SERVER Managment Studio.

and now I want drop database, I get this error "Drop failed for Database DBNAME ... Cannot drop database DBNAME because it is being using Replication"

How to I drop this database ?

And where registred this replication information ?

Regards,

Mahir Quluzade

I executed this script and droped database.

use master
go
exec sp_removedbreplication 'DBNAME'

I found solution my problem.

I use this book : "Pro SQL Server 2005 Replication"

Regards

Mahir Quluzade