Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Overwriting a table which is replicated Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 7:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 3:23 AM
Points: 115, Visits: 93
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.
Post #1467135
Posted Tuesday, June 25, 2013 9:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 4:44 AM
Points: 227, Visits: 665
Hi abhij33t,

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

Regards, Iain
Post #1467221
Posted Tuesday, June 25, 2013 9:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 3:23 AM
Points: 115, Visits: 93
Yes... the Current DB is going to be restored from a backup of Production server every 10 days.
Post #1467224
Posted Tuesday, June 25, 2013 9:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 4:44 AM
Points: 227, Visits: 665
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.
Post #1467249
Posted Saturday, June 29, 2013 5:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 3:23 AM
Points: 115, Visits: 93
But if I restore from another server where there is no replication setup on the DB, would the Publisher still work after restore ?
Post #1468787
Posted Sunday, June 30, 2013 6:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 4:44 AM
Points: 227, Visits: 665
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.
Post #1468860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse