June 25, 2013 at 7:24 am
Hi,
I have 3 tables in a database in SQL Server 2005, which are replicated through a transactional replication to 3 different servers. Recently client stated a requirement that we need to refresh the DB containing these tables.
My question is - What is the simplest method to make sure that replication runs smoothly after the DB is refreshed.
June 25, 2013 at 9:07 am
Hi abhij33t,
It isn't really clear what you are intending to do. Are you dropping and recreating the database?
Regards, Iain
June 25, 2013 at 9:13 am
Yes... the Current DB is going to be restored from a backup of Production server every 10 days.
June 25, 2013 at 9:42 am
Assuming that your backup will contain the most recent data for the tables, then you shouldn't need to do anything. If the data in the restore is different to the data at the local sites, then I'd just reinitialise each subscriber.
June 29, 2013 at 5:06 am
But if I restore from another server where there is no replication setup on the DB, would the Publisher still work after restore ?
June 30, 2013 at 6:11 am
Well that's a different case, clearly. If you do this, you'll have to set up replication on the restored database. Then I'd probably just drop and recreate the subscriber tables and their subscriptions.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply