> > > To mirror or not to mirror? That is the question at hand > > > these days. > > > > > > RAID-5 with hot-swappable disks? > > > No it's not at the disk level but at the databse level. > <http://www.microsoft.com/technet/community/events/sql2005/sql-03.mspx> you can download the movie . "Configuring a Database Mirror. In this demonstration, we will cover how to configure a mirror of a database. We will cover the use of a witness server to enable automatic failover. We will then access the principal database in a mirror set and then attempt to access the mirror database. We will simulate the failure of the principal database and attempt to access the original mirror database to demonstrate that Automatic Failover occurred."
I see. So many variables that it's hard to offer an opinion. I guess if you look at the history of the application and it's future requirements and assess how this technique would add value, that would give you the information you need. Maybe try it with a small app first and get some experience with it, before using it for larger apps. Bill _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
