January 29, 2015 at 10:45 am
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
January 29, 2015 at 10:46 am
How do I do that?
January 29, 2015 at 4:34 pm
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
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2015 at 8:13 pm
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
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply