Post reply

Problem in Replication

  • May 9, 2012 at 8:42 am

    #256104

    Hi Friends,

    I am trying to do a snap shot replication over cross servers....mine is 192.168.14.200 and the subscriber server is 16.178

    database is created on the subscriber machine but objects are not created...

    please help me friends...where i am making mistakes?

    Thanks,
    Charmer

  • May 9, 2012 at 8:54 am

    #1485115

    How big is the database? It could take a while to push the snapshot over there if its big, in which case you might want to just backup and restore to initialize the subscription.

    The probability of survival is inversely proportional to the angle of arrival.

  • May 9, 2012 at 8:56 am

    #1485118

    sturner (5/9/2012)

    How big is the database? It could take a while to push the snapshot over there if its big, in which case you might want to just backup and restore to initialize the subscription.

    database size is just 177MB..Replication files are stored on my local machine path...is that going to be problem? for cross server replication do i need to store files on a share folder or some where?

    Thanks,
    Charmer

  • May 9, 2012 at 9:01 am

    #1485121

    look in the snapshot log and/or the sql server logs, something is (or is not) happening as it should.

    The probability of survival is inversely proportional to the angle of arrival.

  • May 9, 2012 at 9:10 am

    #1485128

    sturner (5/9/2012)

    look in the snapshot log and/or the sql server logs, something is (or is not) happening as it should.

    Thank you Sturner...as you told, it takes some time to get the objects..now i see slowly objects are created...:-)

    Thanks,
    Charmer

Viewing 5 posts - 1 through 4 (of 4 total)

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