how to remove subscriptions items of sqlserver 2000

Sir,
I am unable to remove replication (subscriptions items) from subscriber
database which has been removed from publications database.
I would be very much grateful if anyone could help me.
with regards,
chewang dorjiIf the wizards did not drop subscriptions correctly and some items still
seem to be replicated and have subscribers, you will have to use system SPs
to do the job. Check the sp_removedbreplication, sp_droppullsubscription,
sp_dropsubscription and related procedures in Books OnLine. If you are
talking only about the tables created on the subscriber, you have to drop
them manually - use the Drop Table statement.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Chewang Dorji" <drukfood@.druknet.bt> wrote in message
news:u9CTafRbDHA.2372@.TK2MSFTNGP10.phx.gbl...
> Sir,
> I am unable to remove replication (subscriptions items) from subscriber
> database which has been removed from publications database.
> I would be very much grateful if anyone could help me.
> with regards,
> chewang dorji
>

How to re-establish subscriptions DB using Backup of Subscriber Db?

BOL 2000 makes reference to recovering a subscriber DB using a backup of the subscriber DB but does not appear to say how to go about doing it. What I need is enough info on how to set-up a backup and recovery strategy that can be implemented in a production environment. Snapshot recovery is no longer acceptable and there are lots of identity columns. Push publication.

It should be rather cook-book and I am hoping you can point me to a doc that will allow me to achieve this. It should be rather cook-book and I am hoping you can point me to a doc that will allow me to achieve this.

Thanks

Michael

Hi,

This KB article lays out the steps required to setup subscription using backup: http://support.microsoft.com/kb/320499.

Peng

|||

The article you referenced does not address using Subscriber backups. Only Publisher backups. A nice idea, but not what I asked for.

Thanks

|||

OK. So I assume you are looking for a recovery plan for your subscription database. You can take a look at the documents in SQL 2005 BOL http://msdn2.microsoft.com/en-us/library/ms152560.aspx. I know it is not exactly what you ask for because the document it is for SQL 2005. But they are very close. Basically, the steps are as following:

1) check if the backup is older than the retention period. If yes, reinit the subscription. Otherwise, goto next step

2) restore the backup

3) If you have pull subscrption, check it. You may need to reinit if the subscription information is not up-to-date

4) restart the distribution agent

Peng

sql