July 18, 2017 at 11:38 am
Distribution agent job fails with below error message for Transactional replication.
Cannot drop the table 'dbo.XYZ' because it is being used for replication.
July 18, 2017 at 11:54 am
DBA_007 - Tuesday, July 18, 2017 11:38 AMDistribution agent job fails with below error message for Transactional replication.Cannot drop the table 'dbo.XYZ' because it is being used for replication.
If there is a question here, it's very well hidden.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 18, 2017 at 12:09 pm
DBA_007 - Tuesday, July 18, 2017 11:38 AMDistribution agent job fails with below error message for Transactional replication.Cannot drop the table 'dbo.XYZ' because it is being used for replication.
Usually it's because the table is already part of an existing publication.
Or you restored the subscriber that was part of another replication.
Sue
July 18, 2017 at 12:32 pm
yes, its a re-publisher
July 18, 2017 at 1:21 pm
DBA_007 - Tuesday, July 18, 2017 12:32 PMyes, its a re-publisher
There can be dozens of different things as it depends on what you are doing/changing, how that table is used, etc. etc.
If you are adding or dropping articles, refer to this link:
Add Articles to and Drop Articles from Existing Publications
If you are changing properties for publications or articles, refer to this link:
Change Publication and Article Properties
If you are making schema changes, refer to this article:
Make Schema Changes on Publication Databases
If you are totally redoing a publication, drop the existing and then create the new publication. To drop the existing, refer to this article:
How to: Delete a Publication
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply