Remove Replication

I have taken a backup from replicated database and restore it in another server, but can't edit or delete tables from that database it saying " Cannot add columns to table 'tblMastTestHeader' because it is being published for merge replication "

more ▼

asked Oct 28, 2009 at 04:07 AM in Default

avatar image

11 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Backing up and restoring replicated databases in SQL 2000 can be a real headache. We do this once a month and still occasionally come up with issues. Sometimes sp_removedbreplication simply doesn't work, and I have had to drop replication for the entire server and rebuild it (ie turn off publishing and distribution).

Frank, you seem to be asking a different question (one about stored procedure) than the first one in this series, so it might be better if you submitted it as a new question instead of trying to piggyback. It will help if you can post the results of the removedbreplication proc, as well as the error you receive when trying to drop the stored procedures.

more ▼

answered Nov 16, 2009 at 02:11 PM

avatar image


(comments are locked)
10|1200 characters needed characters left

Have you tried running sp_removedbreplication?

more ▼

answered Oct 29, 2009 at 10:46 AM

avatar image

1.7k 2 3 6

(comments are locked)
10|1200 characters needed characters left

i have the same problem and have use the sp_removedReplication, but the problem i have is that cant drop the SPs and they are marked in sysobjects with 512 in the replinfo field, have anyone and idea how to change this or force the dropping of the sp??

more ▼

answered Nov 12, 2009 at 05:00 PM

avatar image


(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 28, 2009 at 04:07 AM

Seen: 1726 times

Last Updated: Oct 29, 2009 at 10:17 AM

Copyright 2018 Redgate Software. Privacy Policy