Transaction Replication

Question

Post reply

Transaction Replication

subbarayudu.net 37258

Mr or Mrs. 500

Points: 540
More actions
March 6, 2010 at 5:18 am

#386451

Hi Everybody,
I am new in Replication pls help me.
In my environment Transactional replication is already existed [ One publisher and 10 Subscribers ]
last 5 months on words its running very smoothly, Suddenly this Tuesday [ March 2,2010 ] one subscriber
[ Out of 10 ] is down.
After that i get errors in my replication.What can I do,again my replication is working pls help me
Subbarayudu

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

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

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

Please post the errors you are getting.

Without seeing the error message, it is difficult to help.

Replication can be down for different reasons.

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 2

Actually that scinorio asking my Project manager. so i kept those steps in my post.

Please help me what will happened in both sides [ Publisher and Subscriber ]

Subbarayudu

steveb. SSC-Forever Points: 46733 More actions · Answer 3

You will need to post the error messages from your publisher, distributor and subscriber.

There will be a reason the subscriber is down and the error logs should tell you that, most likely the subscription has expired for some reason..

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

From what I read, I do not think it has happened in their environment. It was a theoretical question raised by the Project manager/Interviewer.

Lots of reason for the Subscriber to go down and depending on the error, there are ways to fix those issues.

-Roy

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 5

Hi Sir's,

Just give me information only.

I need the information only, Once Existing subscriber is down what will happen in Publication,Distrubution and Subscriber end.

Just i need the information.

I don't want to any errors and fixing information for the above scenario

Thanks

Subbarayudu

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

Pretty much nothing.

Distribution might grow, because of having to retain transactions.

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

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 7

subbarayudu.net 37258

Mr or Mrs. 500

Points: 540

March 10, 2010 at 6:26 am

#1131309

Thanks

Gila.

Any other comments please,

Regards

Subbarayud

GSquared SSC Guru Points: 260824 More actions · Answer 8

Well, that particular subscriber will no longer be synchronized. Other than that, it'll depend on what caused it to stop working.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 9

Hi Roy ,

Can you share this discussion please

Thanks

Subbarayudu

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 10

The best way to get more general info is reading about it. You can find tons of information regarding it in Google, BOL and the articles in SSC.

Seems like you have lots of questions regarding SQL Server in general. The best way to get information is to start reading regarding the topics and if there is something you did not understand, ask here and we will help you. We would like to see you talking some steps first.

At least that is where I stand regarding learning and getting information...

-Roy