Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-02-07 : 07:19:10
|
| Dear All,I’m having three databases with same data in three different locations. Now three users adding records to the particular databases respectively. I want all the data from server A to be there at aerver B and C. all the updations at server B should be there at Server A and server C. as well as same updations at C also. It is not possible to implement replication as all the servers are at long distance. How can I update every database with the other server’s data? I’d like to update day wise. Is there any tool to generate script on that particular date period? Experts, I think you understood my scenario, please let me know the tools or list of best possibilities for me.I’m thinking of Incremental backup. Guide me in this scenario.Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 20:04:45
|
| Use peer to peer replication if you use sql2k5. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-02-08 : 01:19:25
|
| actually those are not connected to each other to implement peer to peer replication |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 01:35:50
|
| What do you mean? How can you sync them if there is no connection. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-02-08 : 03:46:49
|
| that is the problem now. is it not possible to do that manually? generating script only for the particular day transactions?i've just found one tool SQL SCRIPTER. but that is giving for all the complete data. i need the data only day wise. guide me in this regard. it is an urgent issueVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-02-08 : 04:33:54
|
| I'm thinking of creating a job to take incremental backup daily at the three places and restoring them in the rest of places. Dear Experts, please let me know about my idea of doing this as this is an important task for me.VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-08 : 04:41:57
|
| incremental backup? I dont think there's incremental backup in sql server.Are you refering to differential backup? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 21:38:15
|
| If you do backup/restore, it'll override target db. So it's not kind of merge you want. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-02-12 : 04:34:35
|
| yes.i'm saying regarding differential backup. doesn't it work? then what is the solution for this one?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
database synchronization help