2 replicated objects (tables) not being created on the subscriber

Question

2 replicated objects (tables) not being created on the subscriber

Welsh Corgi

SSC Guru

Points: 116520
More actions
September 10, 2015 at 7:04 am

#307603

I'm in the process of migrating over nearly 900 reports to a replicated server.
I have moved over 100 reports, stored procedures and their dependent objects so far.
I have two tables that are not being applied to the subscriber.
I can be searching for an answer.
Has anyone experienced this problem and what did you do to resolve it?
:unsure:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Have you checked the replication agent logs for errors?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

no.

I checked the Snapshot Agent and Log Reader Agent but I can't determine how to navigate to the Distribution Agent?:blush:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I checked the Distribution Agent Log and there were nor errors.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

Have you checked the properties of the publication to verify that the two tables are included as articles in the publication?

John

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

John Mitchell-245523 (9/10/2015)
Have you checked the properties of the publication to verify that the two tables are included as articles in the publication?
John

John ,

Yes they are there.

It is up to 4 tables now.

It occurs at random.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

zygonr Old Hand Points: 329 More actions · Answer 6

Hi

As we have no errors , are you performing using GUI. Did you try scripting the replication and run it see if you get an error.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 7

What type of replication are you using? How frequently does it run? What do you mean when you say the tables are not being applied - not created, or created but contain no data. What about tables in the publication database - is the data in them fairly static, or does it have lots of inserts and updates and deletes?

John

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

zygonr (9/10/2015)
Hi
As we have no errors , are you performing using GUI. Did you try scripting the replication and run it see if you get an error.

How do I script it out?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

John Mitchell-245523 (9/11/2015)
What type of replication are you using? How frequently does it run? What do you mean when you say the tables are not being applied - not created, or created but contain no data. What about tables in the publication database - is the data in them fairly static, or does it have lots of inserts and updates and deletes?
John

Transaction replication.

It runs continuously.

The object are going from the publisher to the distributer but they never make it to the subscriber.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/