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 |
|
colin
Starting Member
2 Posts |
 Posted - 2010-03-02 : 13:54:34
|
| I'm really new at this and would appreciate a little advice in steering me in the right direction. I have developed a database on localhost and also have manually created copies of it on two external hosting services that I use. I can probably use backup/restore to get the database fully synchronized with one host but the other uses some proprietary backup scheme that I haven't explored yet. However, my real question is this...once in production, what's the best way to have data written to one of the external hosts copied to the other external host? I'm hoping for some automated procedure so that this can occur in near-realtime. I do have MS SQL Server Management Studio Express connected to the two external hosts and my localhost. One last catch...one external host is SQL Server 2000 and the other is 2005. Any advice will be greatly appreciated. |
|
|
chanti2985
Starting Member
4 Posts |
Posted - 2010-03-03 : 03:44:48
|
| do u know about highavailabilty concepts.any highavailabity concept do your work.srikanth. |
 |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-04 : 20:50:28
|
| Which editions of SQL Server are you using and what do you expect the "copy" database to be able to do? Is it just a warm spare that is waiting for the other system to go down, or is it actually expected to be queried? As Srikanth mentioned you should google high availability strategies. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Keeping databases on remote servers synchronized?