They are not apples to apples. Mirroring is on the database level and you
can't mirror the system DBs. Mirroring can also be setup in various way or
degrees of HA. Clustering is at the machine level. What kind of HA are you
looking for?

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


[quoted text, click to view]

Hello

Just wondered what peoples opinions were on the advantages of using
clustering over DB mirroring introduced in SQL 2005? From what I can see
having briefly looked into things is that the mirroring offers potentially a
less complex and cheaper solution not to mention the fact that you can have
mirrored databases in seperate locations. Are there any decent articles
around that compare the two options?

Thanks - Jack.

Check out:

http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters/default.aspx

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
Hello

Just wondered what peoples opinions were on the advantages of using
clustering over DB mirroring introduced in SQL 2005? From what I can see
having briefly looked into things is that the mirroring offers potentially a
less complex and cheaper solution not to mention the fact that you can have
mirrored databases in seperate locations. Are there any decent articles
around that compare the two options?

Thanks - Jack.