Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 9,241 total)

  • RE: Instance failover failing in Cluster

    Benki Chendu (4/19/2014)


    I am getting the following error when I am trying to failover an instance to another node:

    The operation failed because either the specified cluster node is not the...

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

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

  • RE: Why every SQL Server installation should be a cluster

    No, actually they would probably reply "exchange server".

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

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

  • RE: Re-named failover nodes for SQL cluster and broke it!

    Hmm renaming should have worked if the old computernames werent removed.

    Trying getting your AD admin to reset the computer accounts for each node (right click in AD and select...

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

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

  • RE: sql server and ram

    Brandie Tarvin (4/18/2014)


    But none of us recommend you lower the max memory setting unless you know the consequences.

    You would do if your server starts blue screening because its under...

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

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

  • RE: Why every SQL Server installation should be a cluster

    quackhandle1975 (4/18/2014)


    depends on what people are comfortable with supporting/administering, or have been forced to support

    You've just countered your own argument there, by deploying nothing but Windows clusters to support purely...

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

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

  • RE: sql server and ram

    Tony Sweet (4/17/2014)


    It does not release RAM until you cycle the service or the OS tells it to give up the RAM.

    or if you lower the max memory setting

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

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

  • RE: Re-named failover nodes for SQL cluster and broke it!

    dgraf (4/17/2014)


    Hi all,

    I had a cluster running on 3 nodes (windows failover cluster) with server 2012 and SQL server 2012 running in the cluster. Well, I thought I'd just go...

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

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

  • RE: Register SPN for SQL Service account

    No, I think the SPN formats section is getting people confused, it's an either\or situation. If you check the material it's detailed that when using TCP an SPN is always...

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

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

  • RE: Why every SQL Server installation should be a cluster

    Francis Apel (4/16/2014)


    Bill (DBAOnTheGo) (4/16/2014)


    Personally I'd like to make sure this is out there. Francis Apel, we do appreciate the article and you writing here. Not everyone will agree and...

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

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

  • RE: Why every SQL Server installation should be a cluster

    Cody K (4/16/2014)


    Perry Whittle (4/16/2014)


    You'll always deploy to a dev and\or test system first so you'll know beforehand if the patch has an impact.

    Sure, in the land of unlimited budgets....

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

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

  • RE: Renaming a filegroup

    you're welcome

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

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

  • RE: Register SPN for SQL Service account

    the first question is, which protocol are you using to accept connections to your sql server, which protocols do you have bound?

    from memory IPX\SPX would not be able to provide...

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

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

  • RE: All the 3 jobs are running successfully but Restoration in Secondary server is not happening

    Jagadeesh Chowdary (4/16/2014)


    Hi Sir,

    Can please Elaborate the above Step.

    I have observed that restore job is not running and showing the following error message but when i checked that all the...

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

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

  • RE: SQL Virtual Network Name Change Error

    It's a permission issue on the AD side, you'll need to pre stage the VCO, this link gives more detail

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

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

  • RE: In Log shipping Copy Job is not Running successfully...

    firstly check permissions to the backup share location where the log backups are to be copied from. The sql server agent service on the LS secondary will need permission to...

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

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

Viewing 15 posts - 3,346 through 3,360 (of 9,241 total)