Overwriting a table which is replicated

  • 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.

  • Hi abhij33t,

    It isn't really clear what you are intending to do. Are you dropping and recreating the database?

    Regards, Iain

  • Yes... the Current DB is going to be restored from a backup of Production server every 10 days.

  • 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.

  • But if I restore from another server where there is no replication setup on the DB, would the Publisher still work after restore ?

  • 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