Forum Replies Created

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

  • RE: backup, differental and transactions

    Just a tip, change the ALTER PROCEDURE to a CREATE PROCEDURE and the script will execute.

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

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

  • RE: Powershell and Alwayson Question

    have you first added the new replica to the AlwaysOn group?

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

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

  • RE: Please create a master key in database of open master key in the session before performing this operation. Error 15581

    That will just force a regeneration of objects protected by the service master key. Have you created a database master key in master yet?

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

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

  • 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" 😉

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