471,093 Members | 1,982 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,093 software developers and data experts.

replication or mirroring

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

Oct 2 '07 #1
1 2995
(mm*********@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, es****@sommarskog.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
Oct 2 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Colin Mangiagalli | last post: by
4 posts views Thread by Mulder | last post: by
1 post views Thread by GB | last post: by
1 post views Thread by Jon Brisbin | last post: by
4 posts views Thread by aleu | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.