| Author |
Topic |
|
shreyasingh5
Starting Member
3 Posts |
 Posted - 2008-06-24 : 15:34:04
|
| I have a file server and Databases in two different locations. One location is the exact replica of the other. Right now replication is done using some of-the-shelf software but I was looking if there exists some technique to synchronize the database without using any tools.Have anyone come accross any research papers in this area or have implemented any such techniques. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-24 : 15:37:26
|
| You could try SAN mirroring/replication, database mirroring, log shipping, ...But I don't know what you mean by "without using any tools". You have to set something up in order for it to send the data. There's no magic here.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-24 : 15:48:49
|
| I think she meant third-party tools. Tara, I have heard about SAN mirroring for Cluster in two different location. Do you know how good and expensive is it?Shreya, If you want real-time synchronization(Automatic) ,you should go for Database mirroring or Clustering and Transaction rep,log shipping for warm standy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-24 : 15:55:15
|
quote:
Originally posted by sodeep
Tara, I have heard about SAN mirroring for Cluster in two different location. Do you know how good and expensive is it?
It's very good and very, very expensive. We were quoted in the 7 figures.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-24 : 16:12:25
|
quote:
Originally posted by tkizer
quote:
Originally posted by sodeep
Tara, I have heard about SAN mirroring for Cluster in two different location. Do you know how good and expensive is it?
It's very good and very, very expensive. We were quoted in the 7 figures.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
God!! Thats what we were being told too. |
|
|
|
shreyasingh5
Starting Member
3 Posts |
Posted - 2008-06-24 : 16:14:21
|
| Thanks for the reply,Rather than tools I was looking into techniques and protocols for Data replication and synchronization. we just wanted to see if it would be feasible to go for inhouse development or implement some third party tools.If you have any tried sth similar please tell me about it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shreyasingh5
Starting Member
3 Posts |
Posted - 2008-06-24 : 17:53:27
|
| I want to make each server independent yet synchronized. By independent i mean there should not be any master/slave relation between the databases. I mean changes can take place in any database and that should be reflected in both. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-24 : 18:19:15
|
| Take a look at Peer-to-Peer to replication. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-25 : 09:47:36
|
| Tara, I have heard that SAN replication is too much expansive then the Litespeed Logshiping.SAN = $13.58/GB of usable storage per year EFS/NAS Tier = $17.95/GB of usable storage per year And also SAN Replication need 3SAN if you wanted to replicate data from one(Source) to other(Target).ManojMCP, MCTS |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Synchronization Problem