I have a transactional replication(with initialize from backup) setup in my server.
So i setup replication as below: Used full backup(publisher database full back is scheduled every night) from the previous day of the publisher database. Did restore of the full backup in the subscriber and then created publisher and subscriber. While creating subscriber,i took a differential backup and used it to synch.
And everything works fine. After two days,i noticed that i missed to add a table in the publisher/subscriber.
- Now is it possible to add that table into the publisher/subscriber.?
- If i create a separate publisher for that table,when i create subscriber for the new publisher ,what backup i should use?Already two nightly scheduled full backup and several transactional backup are generated,so how can i synch from the full backup i used to restore in the subscriber.