Post reply

Transaction Replication

  • 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

  • March 8, 2010 at 2:35 am

    #1129880

    Please post the errors you are getting.

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

    Replication can be down for different reasons.

  • March 8, 2010 at 4:41 am

    #1129920

    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

  • March 8, 2010 at 4:56 am

    #1129925

    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..

  • March 8, 2010 at 9:28 am

    #1130101

    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

  • March 10, 2010 at 5:55 am

    #1131283

    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

  • March 10, 2010 at 6:10 am

    #1131297

    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

  • March 10, 2010 at 6:26 am

    #1131309

    Thanks

    Gila.

    Any other comments please,

    Regards

    Subbarayud

  • March 10, 2010 at 6:39 am

    #1131322

    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

  • March 10, 2010 at 6:48 am

    #1131335

    Hi Roy ,

    Can you share this discussion please

    Thanks

    Subbarayudu

  • March 10, 2010 at 6:53 am

    #1131342

    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

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

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