Post reply

Transactional Replication without snapshot

  • January 24, 2011 at 9:50 pm

    #1277598

    Has the database backup which u r talking to restore been taken after the replication is set?

    Satnam

  • January 24, 2011 at 10:03 pm

    #1277601

    Satnam Singh (1/24/2011)

    Has the database backup which u r talking to restore been taken after the replication is set?

    Satnam

    The backup is of the publication database, which is being replicated previously.

  • January 24, 2011 at 10:12 pm

    #1277602

    Thanks for that.

    Ideally the replication information is stored in the distribution database ie information regarding publishers, subscribers and so on. Therefore restoring the publisher database again will not be able to regenerate the replication again. What u can do is first take the backup of the replication scripts and then execute it after restoring the publisher database. After executing the replication scripts again u will need to take the snapshot of the articles again and also i believe the log reader agent need to be restarted again.

    Hope this helps.

    Satnam

  • January 24, 2011 at 10:22 pm

    #1277604

    Satnam Singh (1/24/2011)

    Thanks for that.

    Ideally the replication information is stored in the distribution database ie information regarding publishers, subscribers and so on. Therefore restoring the publisher database again will not be able to regenerate the replication again. [highlight=#ffff11]What u can do is first take the backup of the replication scripts and then execute it after restoring the publisher database. After executing the replication scripts again u will need to take the snapshot of the articles again and also i believe the log reader agent need to be restarted again.[/highlight]

    Hope this helps.

    Satnam

    Well,what i really dont want to do is creating the snapshot, that is the reason why i want to re-initialize replication using database backup. What do you mean by taking backup of replication scripts?

  • January 24, 2011 at 10:29 pm

    #1277606

    By replication scripts, it means that it is the backup of your replication.

  • January 24, 2011 at 10:33 pm

    #1277608

    Satnam Singh (1/24/2011)

    By replication scripts, it means that it is the backup of your replication.

    Could you provide me with the steps i need to follow for initializing replication from backup

Viewing 6 posts - 1 through 7 (of 7 total)

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