You are here: Re: replication or mirroring « MsSQL Server « IT news, forums, messages
Re: replication or mirroring

Posted by Erland Sommarskog on 10/02/07 22:07

(mmark751969@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@sommarskog.se

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация