January 24, 2011 at 9:33 pm
Hello all,
We have some very large tables in a database which is being replicated(Transactional Replication). Now we want to change the replication so that it doesnt replicate deletes. When i do this, it is creating a new snapshot of all the articles. We are having some problems while the snapshot is being re-created. So i want to restore the database backup and initialize replication once again which is faster than the snapshot which is taking more than 24hrs. -What are the steps to initialize replication from a database backup?
-As we already changed the replication settings "Do not to replicate deletes". Now after restoring the database from backup and using this as subscription, does the replication work normally?
January 24, 2011 at 9:50 pm
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
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
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
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
By replication scripts, it means that it is the backup of your replication.
January 24, 2011 at 10:33 pm
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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply