Timeline for Initializing Transactional Replication From two Different Database Backup
Current License: CC BY-SA 3.0
21 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Oct 4, 2013 at 13:13 | history | edited | Jon Seigel | CC BY-SA 3.0 |
deleted 442 characters in body; edited tags
|
| Oct 4, 2013 at 9:17 | history | tweeted | twitter.com/#!/StackDBAs/status/386057439302651904 | ||
| Oct 4, 2013 at 7:02 | comment | added | Mehrdad Kamelzadeh | see my Edit please | |
| Oct 4, 2013 at 7:02 | history | edited | Mehrdad Kamelzadeh | CC BY-SA 3.0 |
added 1988 characters in body
|
| Oct 3, 2013 at 17:49 | comment | added | Eric Higgins | You've received good advice here, particularly Brandon's. One other thing you can consider is using tools like Redgate's compare to do an initial sync of all the databases, THEN implement merge replication. In the long run that might be simpler to manage. | |
| Oct 3, 2013 at 16:52 | comment | added | Jon Seigel |
do I have any better choice than replication? -- probably. Please edit the question to include all the details about what you're actually trying to accomplish in terms of business goals.
|
|
| Oct 3, 2013 at 15:52 | answer | added | Brandon Williams | timeline score: 2 | |
| Oct 3, 2013 at 15:19 | comment | added | Mehrdad Kamelzadeh | @kin it is enterprise 2008r2 | |
| Oct 3, 2013 at 14:36 | answer | added | RLF | timeline score: 0 | |
| Oct 3, 2013 at 14:01 | comment | added | Kin Shah | @MehrdadKamelzadeh what version and edition of sql server u are using ? Enterprise / standard - 2008R2, 2012 ? | |
| Oct 3, 2013 at 13:45 | comment | added | Mehrdad Kamelzadeh | @Kin the branches in cityB and cityC inserting some customer information and also they scan the customers' documents which these scans make the DB very large. all these data should be replicated into cityA (the boss office). the Boss do some reports, see the documents of the customers etc in cityA with the software I have developed for him. do I have any better choice than replication? someone says you can use SSIS. but I don't know how to track the changes and I haven't done that before. | |
| Oct 3, 2013 at 13:24 | comment | added | Kin Shah |
@MehrdadKamelzadeh I don't know how to restore two different backup --> You cant do it as you will loose data from 1st backup when you restore 2nd backup. I don't know what exactly you mean by entire database. I am asking the need for replicating 200GB database as if something goes wrong, re-initialization will might take hours or days depending on your n/w latency. he wants to monitor all the data coming from cityB and cityC. There might be better ways to monitor data. Need more clarification -- what do you mean by monitor incoming data .. ?
|
|
| Oct 3, 2013 at 13:15 | answer | added | Kin Shah | timeline score: 0 | |
| Oct 3, 2013 at 13:15 | comment | added | Mehrdad Kamelzadeh | @Kin I Do want to initialize fro the backup but I don't know how to restore two different backup. I don't know what exactly you mean by entire database. but the cityB and cityC are the branches of cityA. cityA is the city in which the boss of the company lives. so he wants to monitor all the data coming from cityB and cityC. | |
| Oct 3, 2013 at 13:07 | comment | added | Kin Shah | @MehrdadKamelzadeh So you want to do a many-to-one replication. Refer to my answer here on how you can do it (dba.stackexchange.com/a/43995/8783). It would be tricky as your database is huge ? Why are you replicating your entire database ? Also due to your huge database size, have a look at (dba.stackexchange.com/a/50227/8783). Both links should help you. | |
| Oct 3, 2013 at 12:50 | comment | added | Mehrdad Kamelzadeh | @RLF so what do you suggest for my scenario? I have to replicate two database one in cityB and one in cityC to a central database in cityA. Both are with the same schema and they are about 200GB | |
| Oct 3, 2013 at 12:19 | comment | added | RLF | You cannot do a 'merge restore' of two databases into a single database. Each database is independent. | |
| Oct 3, 2013 at 12:08 | comment | added | Mehrdad Kamelzadeh | @Kin I have two different back up from two different database which their schema are the same but they have different data. according to the link in my question, I have to restore the backup of the database at first and then create the subscription from the backup. the problem is that I have two different database hence two different back up files. how can I restore them both to a central database? | |
| Oct 3, 2013 at 11:59 | comment | added | Kin Shah | Can you clarify restore two different backups to a single database do you have striped backup files ? | |
| Oct 3, 2013 at 11:54 | history | asked | Mehrdad Kamelzadeh | CC BY-SA 3.0 |