CODEWITHSUNDEEP
sql-serverreplicationsql-server-2022invalid-object-name
Manish Joisar
Manish Joisar

Reputation: 1310

Database snapshot replication Invalid object name, Wipe of all data

We have created new publication and then subscription replicate data from D to E database.

Publication is set to run every 10 seconds
Subscription is set to run continuously.

It was working fine and now suddenly we have started getting following issues

We have created around 9 subscriptions with different databases, issue is only for database D to E.

We compared all the tables scripts to identify if there are any discrepancies which may be causing this issue, but no issues there as well.

We have recreated the subscription, reinitialized the subscription but no luck.

In SQL Server Agent, I can see 2 jobs, i.e. one for publication and one for Subscription. When I disable publication Job, issue is getting resolved but now how come new data will be then get updated in subscription database.

I am not sure what is missing out here.

Upvotes: 0

Views: 57

Answers (1)

andrews
andrews

Reputation: 2173

Check the Action if name is in use property of the actual publication article. See if you want to set it to Keep existing object unchanged to avoid table being recreated each time.

enter image description here

Upvotes: 0

Related Questions