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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-26 : 10:40:47
|
| Vlad writes "Dear SQL Team,I have 2 SQL2k servers with service pack 2 installed. One is a primary server where it has database connected to a web site with data entry forms. The second one is a backup with the same database. What I need to do is update the backup server database with data as it gets entered in a primary one, so that if primary server is down by any reason I can reconnect the web to the backup server and have all the latest data in it.Thank you very much in advance,Vlad" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-27 : 00:54:34
|
| I think replication is the solution for you ,check BOL for further details under 'replication'regards,harshal.Expect the UnExpected |
 |
|
|
|
|
|
Realtime update one SQL server with a Data from a second one