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 - 2004-06-18 : 10:08:00
|
| Bill writes "I have a SQL2000 database that is an active/passive cluster. Windows 2003 Enterprise Server latest service packs on sql and Windows.The database has alot (I don't have exact count) of records and tables in the database. It is the backend of our corporate business systems. Has load balanced webservers that retrieve this data by clients and employees as needed, so performance is always of concern.But now to my question..I am looking for a way, software product or other solution that will allow me to replicate my sql db to a "HOT Site" in the event of a disaster.I have some experience with Double-Take from NSI software and it seems OK, but kind of quarky as well..Does anyone have any experience with any other products that will do this, bit/byte level realtime data replication between databases?Any ideas or help would be greatly appreciated." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-18 : 12:33:19
|
| You might consider using log shipping which comes with SQL Server 2000 Enterprise Edition. We use it for site duplication to our disaster recovery site. It doesn't do bit/byte level realtime data replication, but you might want to take a look at it anyway.Tara |
 |
|
|
|
|
|
Database replication