What is the process for removing a replication and then re-creating the replication. I know the process to set up replication. However, If i wanted to take a publisher database copy it and restore it and create another publication and replication how would I do that?
Would I need to remove the previous mesrepl_tran_version column from all the tables???
The type of replication that I will be re-creating is Transactional Replication with updateable subscribers.
Additionally, After I restore the database and create the publication do I need to let the snapshot complete and then back up that database and restore on subscribers and create the subscription
when I restore the database for the publisher can I also restore it on the subscriber?
Help will be greatly appreciated!