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-11-12 : 08:49:47
|
| Samuel writes "The customer is looking to take (5) SQL servers located at a San Francisco site and and copy the databases to a NJ site. We can achieve this with NSI's DoubleTake Software but can they consolidate the number of host to a single multi proccessor system using logical partitions or virtual partiitions. I was thinking about VM Ware at the secondary site to achieve this. Will this be a supported configuration from MS SQL Server?Thanks,Samuel" |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-11-12 : 09:40:09
|
quote:
Samuel writes "The customer is looking to take (5) SQL servers located at a San Francisco site and and copy the databases to a NJ site. We can achieve this with NSI's DoubleTake Software but can they consolidate the number of host to a single multi proccessor system using logical partitions or virtual partiitions. I was thinking about VM Ware at the secondary site to achieve this. Will this be a supported configuration from MS SQL Server?Thanks,Samuel"
If I'm not mistaken Doubletake is used to monitor file changes on a server and send them to another server. This is not the same as SQL Replication.With Transactional SQL Replication you can still copy your transactions to another SQL Server realtime. But for disaster recovery you would also need to keep in mind that all your logins (Standard and Trusted) along with their permissions would be lost... DanielSQL Server DBA |
 |
|
|
|
|
|
Remote site SQL Replication (many to a single host)