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.com) writes:
> 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

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.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx