• Sounds like you have a couple of questions bundled in there. But to your main point yes, you should be able to use a DNS alias to point to a different machine.

    Here's an old thread that may answer some of your questions.

    http://www.sqlservercentral.com/Forums/Topic748728-146-1.aspx