To mirror or not to mirror

Giganews Newsgroups
Subject: To mirror or not to mirror
Posted by:  Marty Shifflett (MartyShiffle…@discussions.microsoft.com)
Date: Thu, 28 Jun 2007

I have posted this once before but I cannot find the thread for some reason.
I have a client that I am going to be doing some colo hosting for.  He has
two brand new servers.  He has not bought any operating systems as of yet and
will also need SQL Server.  The only thing these will be used for is housing
SQL databases for scheduled web data collection and reporting.  I have read
until I am almost cross-eyed but still cannot figure out if I should go with
clustering or just do database mirroring within SQL.  I have another server
which could be used as the witness for mirroring, as well as the file server
for external storage for a cluster.  Can anyone lead me in the best
direction?  Let me know if you have more questions.

Thanks,
Marty

Replies