Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 9,244 total)

  • RE: Cluster is getting Down

    read my stairway!!!

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

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

  • RE: A user DB restarting every hour? Any idea why?

    please post the results of this query when the problem next happens

    select name, database_id, is_auto_close_on, state_desc,

    is_cleanly_shutdown, recovery_model_desc, log_reuse_wait_desc

    from sys.databases where database_id = DB_ID('yourdb')

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

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

  • RE: Cluster is getting Down

    New persopn (12/1/2015)


    Thanks for your information. I think if we are using witness in primary or secondary we will face this cluster fail issue and we are using windows 2012.

    No...

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

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

  • RE: Enterprise Edition Licensing for SQL Server in a clustered environment

    Srl832 (12/2/2015)


    I am fully aware of that Perry. However, we have limited number of Entperprise licenses and I want to know how many licenses we need for the cluster before...

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

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

  • RE: AO Listener creation failed - Error 19471

    Justin Manning SA (12/1/2015)


    Permissions had to be explicitly granted to cluster name

    This is correct

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

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

  • RE: HA/DR debate | VM FCI's with SMB 3.0?

    just let VMware take care of the HA, easiest option, no clustering at the guest level

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

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

  • RE: Enterprise Edition Licensing for SQL Server in a clustered environment

    Srl832 (12/1/2015)


    I am trying to convince management to implement clustering for HA purposes as we only have a DR setup . They want a solution to the HA problem but...

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

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

  • RE: Cluster is getting Down

    New persopn (11/30/2015)


    Hi All,

    We have configured always on with 2 node cluster and both are in different network Zone. In Zone a Node 1 is available, in Zone B Node...

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

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

  • RE: Active-Active cluster + AlwaysOn HA

    GabyYYZ (11/30/2015)


    gotcha...so, to use existing hardware, I'd need to break the cluster.

    No, you would need to expand it.

    GabyYYZ (11/30/2015)


    Would the best recommendation be to create two new instances, one on...

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

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

  • RE: Issue Cluster AlwaysON SQL 2014 SP1

    Perry Whittle (11/27/2015)


    Run a cluster validation and check the report

    ????????

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

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

  • RE: SQL 2012 Error 53

    andyc209 (11/30/2015)


    Trying to run a BCP command and get the following error:

    Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].

    SQLState = 08001,...

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

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

  • RE: How to capture the exact failover time to another node in FCI

    SQL-DBA-01 (11/29/2015)


    Hello Experts

    Can you please tell me how to find the exact time cluster took to failover to another node from existing?

    What are the typical places other than eventviewer I...

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

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

  • RE: Active-Active cluster + AlwaysOn HA

    spanning an availability group across 2 separate clusters is only supported for migration purposes.

    All servers need to be part of the same Windows Server Failover Cluster

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

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

  • RE: Issue Cluster AlwaysON SQL 2014 SP1

    ERIC CRUDELI (11/27/2015)


    Hi,

    The cluster service on each Node is started.

    Regards,

    Eric

    Run a cluster validation and check the report

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

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

  • RE: Issue Cluster AlwaysON SQL 2014 SP1

    ERIC CRUDELI (11/27/2015)


    Error: 35220, Severity: 16, Could not process the operation. AlwaysOn Availability Groups replica manager is waiting for the host computer to start a Windows Server Failover Clustering (WSFC)...

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

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

Viewing 15 posts - 1,531 through 1,545 (of 9,244 total)