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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replicating SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-07 : 11:26:57
Marco writes "Hi,

I am evaluating some tools to replicate my SQL2000 database... I have reviewed some tools like RepliStor from Legato Systems. This is a File System Level replication... but I am not really convinced about it. Do you suggest something else??

I want to replicate my data for disaster recovery.. but also, I want to use the replica for consulting processes, that means that I need both databases up and running in both sides, the source side and the target side. Do you think a file system replication software is a good option for this?? Do you think the SQL replication is better??

Thanks for your suggestions...

Marco"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-07 : 13:48:41
I would suggest trying out the built-in replication in SQL Server first. If you find that it doesn't meet your needs, then demo other products from 3rd party vendors. We use SQL Server replication but not for disaster recovery. For disaster recovery, we use SQL Server Log Shipping.

Tara
Go to Top of Page
   

- Advertisement -