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 |
|
netdeb
Starting Member
2 Posts |
 Posted - 2003-07-23 : 04:46:34
|
| Hello AllI have an Intranet and a Sql Server having all the records in it. And I have a mirror image of the Same database in a remote machine.Both this databases A(In my Machine) and B(Remote Machine) gets updated at any point of time in a day. Now the problem is that I want to schedule a Synchronization technique for the databases and want the latest entered record to be there in both the databases (A and B) without making any kind of data loss or errors.Please explain me the entire process for achiving this requirement as the earliest possible time.RegardsDebaNjaN |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-07-23 : 07:15:54
|
| It sounds to me like you should look into Snapshot Replication.A walk-through of configuring replication does not lend itself to this public forum format. I'd recommend you review the contents of Books Online or some other reference materials. If you have specific questions about replication, this forum will likely help you. If you need someone to do the configuration for you, you should contact a SQL Server consultancy.Jay White{0} |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-23 : 10:06:28
|
| $1,000US he wants bi-directional..what happens when the same keyed record are update (although unlikely) at the same time?I'd say fire triggers to perform the updates, inserts and deletes..but then that's a lot of overhead if it's a high transactional systemBrett8-) |
|
|
|
|
|
|
Immediate Help Needed