SQL 2008 EE :: Adding new article to transactional replication

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  January 29, 2015 at 10:45 am

  #1774100

  I do not have much successful experience with restoring from the backup method. Actually i've never gotten it to work successfully!

  But to take a stab at it, you'll need to drop the constraints at the subscriber in order to get it to work

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• steve.roberts_boohoo

  SSChasing Mays

  Points: 646

  More actions

  January 29, 2015 at 10:46 am

  #1774102

  How do I do that?

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  January 29, 2015 at 4:34 pm

  #1774204

  Personally I would start over again and not used the backup and just go with snaphots (I say this ONLY because I've never had any luck with the restore); however I don't know your environment and am unaware of the hoops you may need to go through to make that happen so...try these links:

  http://stackoverflow.com/questions/16312866/how-to-make-foreign-key-constraints-trusted

  And similarly, https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3a306716-8094-4b00-9a0f-bb568e222c47/transactional-replication-insert-statement-conflicted-with-the-foreign-key-constraint?forum=sqlreplication

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• satnam.singh 44358

  Ten Centuries

  Points: 1300

  More actions

  January 29, 2015 at 8:13 pm

  #1774228

  In order to implement Transactional Replication without a Snapshot for the complete Database you can follow the Guidelines described on the below link.

  http://www.codeproject.com/Articles/447122/A-DBAs-Approach-to-Setup-Transactional-Replication

  With Thanks,

  Satnam