We have a sql server 2000 sp3 server on a win2k3 server standard
edition. This is on dell hardware with a dell scsi dasd enclosure
directly attached. We want to duplicate the hardware and replicate or
mirror the database to the backup server and do a manual or automatic
failover in case of outage(more than likely manual). Wondering right
now if replication - with say software like doubletake - is preferred
over sql database mirroring or vice versa. Thanks

(mmark751969 (AT) yahoo (DOT) com) writes:
Database mirroring is not available in SQL 2000.

When you say replication, you don't mean replication in SQL Server do
you? This can be used to implement a low-budget high-availability solution,
but setting up replication is a little messy. Not talking of failback
to the main server once you've failed over.

I know there are other means of replication which happens on disk level,
but I don't have any experience of it.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx