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 |
|
hendrasd
Starting Member
20 Posts |
 Posted - 2002-12-10 : 20:58:58
|
| Supposed I have two server. Every server has SQL Server DBMS installed, and one instance of SQL Server, say SQLSRV for both server. There is a database in server 1, named DBPendidikan. I want to install the same database DBPendidikan to server 2. Users can access DBPendidikan on both server 1 or server 2. Any data modification on server 1 will directly be applied on server 2, and vice versa, so it can be guaranteed that both server have same data. My question is : Would it be possible to implement the process by using replication ? If it is possible, please tell me the step by step guide … Or how can I implement without using replication ? Is it by using DTC ? Or else ? Which solution is more efficient and effective ? Thanks for your help.-- Never stop learning -- |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-12-11 : 03:10:40
|
| There really isn't an instant way of telling you how to do it. Every scenario of replicating data can be unique and depends mainly on the the application logic (as a whole).You should delve into reading and understading replication, DTS,... and then decide by yourself. |
 |
|
|
|
|
|
Data consistency on two server using replication