I'm creating a DB that is extremeley important to have running all the
time. Not for the importance of the data, but rather to keep the
maximum uptime for the users. The db actually gets dropped, and
recreated and 1,000,000-ish records inserted every night. I would like
to create an identical db on seperate hardware that, in the event of
hardware failure, the users could use while the hardware is getting
replaced. What is the best method (considering no money can be spent
other than my time) to do this?
--Bryan