Problem solve Get help with specific problems with your technologies, process and projects.

Replicating a SQL2000 cluster

Disaster recovery expert Pierre Dorion offers advice on replicating a SQL2000 cluster.

We want to replicate a SQL2000 cluster to a single machine at a DR site. Any ideas on the replication technology we should look at and any pitfalls to watch out for?
There are a number of options available, depending on the type of replication your business requirements and budget will dictate. The possibilities include SQL's native replication capabilities, third-party software-based replication and data replication at the storage level.

Using SQL's built-in ability to replicate is likely the simplest approach, mostly because it does not require the addition of any third-party software or technology. It provides snapshot type replication (point-in-time) as well as transactional replication should there be a requirement for synchronized copies of the database. However, it does require an additional SQL server (subscriber) to be installed and licensed. It also implies strong SQL skills.

There are third-party software solutions available that build on SQL's native replication capabilities. They typically provide a relatively more user friendly interface with add-on features that can be useful for troubleshooting, such as a log view of replication failures down to the a single record level. That said, these solutions must be purchased separately and still require a licensed database server at the receiving end.

Another option is replication at the storage level, which can be accomplished via either hardware or software depending on the storage array used. This approach does not necessarily require an additional licensed server unless combined with a high availability cluster component. Data can simply be replicated and synchronized to a distant volume. Typically, this type of solution requires in-depth skills as a number of configuration files and parameters must be taken into consideration to ensure database integrity.

Dig Deeper on NAS devices

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.