Replication of the SQL-Server

Question

Replication of the SQL-Server

thomaswolf

SSC Rookie

Points: 35
More actions
April 9, 2012 at 5:24 pm

#258910

Hello
I try to get knowledge of the replication scenarios within the SQL Server 2008 R2. So I tried the first Step of the Stairways of the replication available on this website. All went like clockwork, every step was succsessful. Only: I never get the data in the replicated Database (ReplB). My SQL does not create any table in the replicated DB. Do you have any ideas what could be the matter?
Thanks and regards
thomas

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

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

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

Without a lot more detail on what steps you did, what you checked, what (if any) errors, etc, no, no ideas.

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

thomaswolf SSC Rookie Points: 35 More actions · Answer 2

I made exactly and all which is written in the Stairways Level 1 (http://www.sqlservercentral.com/articles/Stairway+Series/72274/). I got no error message, all was successful as it is written and shown in the stairways. It is wrtitten there 'Success! ... A couple of minutes after you finished the setup you can run Script 3 to verify that replication pushed all the data to the subscriber as expected.' I waited over 15 minutes and expected a new table in my subscribed ReplB which I did not get.

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

Is SQL Agent running?

Are all the replication agents running?

What does replication monitor show?

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

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 4

What is returned from the following query?

select * from distribution.dbo.MSsubscriptions

... or if there is an error message, what is the message?

Converting oxygen into carbon dioxide, since 1955.

jitendra.padhiyar SSCertifiable Points: 5824 More actions · Answer 5

Is TCP\IP and named pipe services enabled ?

To enable them you need to go to Configuration tool--> SQL Server configuration manager-->SQL Server Network Configuration and on the right pane click on TCP\IP and Named pipe services and enable them.

Please note that you have to restart SQL Server services after you enable those protocole services.

thomaswolf SSC Rookie Points: 35 More actions · Answer 6

This brings me a Table with 3 Rows. Publisher_dba is always 'Repla', the subscriber is twice 'virtual' (ID -1 + -2) and the third time Replb with ID 1

thomaswolf SSC Rookie Points: 35 More actions · Answer 7

SQL Agent is running.

Are all the replication agents running? -> I do not know. Which services do need to run and where do I find it?

Replication monitor: See attachments. Does this help?

thomaswolf SSC Rookie Points: 35 More actions · Answer 8

I enabled the TCP\IP and named pipe services.

Then I changed the owner of all ServerAgent Jobs to SA and IT WORKED.

Thank you very much for all your help.