• faisalfarouqi (6/25/2014)


    Yes...that is absolutely correct. Do you think by any chance this is a possible solution.

    Regards,

    Faisal

    No, it's not even remotely possible!!

    Here's what you could do (and incidentally what i would do).

    Leaving the standalone instance running on the original server attach your new shared storage to the new server and create a single node windows cluster.

    With the cluster online, install a new failover cluster instance of sql server.

    Once the new instance is online migrate all objects (user databases, agent jobs, logins, packages, linked servers, etc).

    Once the new cluster instance has been fully commissioned flatten the old server and complete a fresh install of the OS. Attach the shared storage to this node too and then join it to the windows cluster.

    Once done run the addnode wizard to join the SQL server Failover Cluster Instance.

    😎

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉