SQL Server Performance

created cluster, them moved nodes to other AD OU

Discussion in 'SQL Server Clustering' started by NorthTec, May 14, 2007.

  1. NorthTec New Member

    Hi guys,
    Excellent bunch of people and resources here - one of my most visited sites lately!!

    We created a cluster on win 2003 ent ed with two nodes, which was working fine - so setup SQL on one instance - was also running fine.

    We later realised the nodes weren't assigned to the correct OU in active directory to have the group policies applied ...
    Sooo - moved the nodes into their proper OU, did gpupdate and now our virtual cluster has dissappeared!!

    (despite reading this article after moving OU's)


    We've already done a fair bit of configuration of SQL schema, and our front end based on the cluster backend.

    Do you know if theres a way to create a new virtual cluster (or get back the old one) and restore our existing schema etc so that the front end never notices that it ever left??
  2. satya Moderator

    Can you explain a bit about what kind of configuration you have setup on SQL Server.
    The option available is to restore system databases along with user databases from this instance to that newly created instance.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. NorthTec New Member

    Thanks for the response satya.<br />We create a new OU and put the Server in this via Active Direcotry.<br />Set the cluster service to automatic (was disabled), did a restart and all's back to normal again. <br />Easy Peasy <img src='/community/emoticons/emotion-1.gif' alt=':)' />

Share This Page