Forum Replies Created

Viewing 15 posts - 7,471 through 7,485 (of 9,244 total)

  • RE: HELP= default instance is missing from node B

    hydbadrose (10/27/2010)


    The default instance is missing or not visible on node b.

    Curious, what makes you think the instance is not installed on Node B?

    Did you install the instance originally?

    If so,...

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

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

  • RE: PAE Enabled without /PAE Switch ?

    what do you have in the boot.ini?

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

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

  • RE: Bounce sql server

    sqlstart wannabe (10/28/2010)


    i can just failover the services and reboot the machine, am I right?

    Just reboot the node it will automatically failover any services, no need to do it manually!

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

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

  • RE: Moving clusters to new hardware - best plan?

    Brian B. (10/26/2010)


    I'm trying to come up with a good migration strategy that will minimize downtime for the following scenario:

    Right now we have

    SQLC cluster, Active/Passive on SQLC1, SQLC2, drives D:...

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

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

  • RE: Replace servers in cluster

    Jonas L (10/27/2010)I dont want to risk that one server is some kind of "master"

    there is no concept of master here, all nodes are equal!

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

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

  • RE: Add a node to an existing cluster

    BigSam (10/27/2010)


    I know how a 2-node active/passive cluster works. I thought I knew how a 3-node cluster works until I started reading your responses. My assumption with a 3-node cluster...

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

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

  • RE: Add a node to an existing cluster

    BigSam (10/27/2010)


    I was hoping I could have 2 nodes active simultaneously.

    You can for diffrent instances, that is an active\active cluster.

    BigSam (10/27/2010)


    Sorta renders the prospect of 3 or more...

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

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

  • RE: Do you need to install SERVICE PACK on SQL Client Tool?

    hydbadrose (10/26/2010)


    Please help= I am not sure if I have to install the sp2 on sql 2008 client server?

    Please try and post in the correct forum location, it avoids a...

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

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

  • RE: HELP= default instance is missing from node B

    go into add\remove programs on that node, do you see sql server installation information here?

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

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

  • RE: Add a node to an existing cluster

    BigSam (10/25/2010)


    I may go to active-active-passive.

    This is a misconception, the cluster is either active\passive or active\active!

    BigSam (10/25/2010)


    I'm currently running Win2k8 std, and SQL2k8 std; will I need to upgrade to...

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

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

  • RE: Replace servers in cluster

    If you really want to keep the same node configs do the following

    ➡ Remove one of the servers from the SQL Server clustered instance(s) by uninstalling the software.

    ➡ Evict\remove the...

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

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

  • RE: SQL 2008 R2 Installation account question

    could you post a screenshot of the logins section from SSMS

    Also, did you install the instance in windows or mixed mode

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

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

  • RE: SQL 2008 R2 Installation account question

    Kwisatz78 (10/20/2010)


    I have installed SQL under a local admin account

    previously you have said that you used a domain account for each service, so what accounts did you use domain or...

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

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

  • RE: How to remove a SQL Cluster Resource Group from AD

    Duran (10/26/2010)


    Hello,

    I know what you mean, I just wanted everything to be uniform.

    Regards,

    D.

    I can understand that, but you're making a whole lot of extra work for yourself. What if the...

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

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

  • RE: How to remove a SQL Cluster Resource Group from AD

    Duran (10/25/2010)


    having ran Cluster Res on the command line I notice that the network name I want to use is already pointing to another resource group.

    Is it really that much...

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

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

Viewing 15 posts - 7,471 through 7,485 (of 9,244 total)