Forum Replies Created

Viewing 15 posts - 2,806 through 2,820 (of 9,241 total)

  • RE: Failover Cluster in SQL 2012 in not auto switch when stop service SQL

    This is not an error it is default cluster resource Failover policy behaviour.

    Open the properties for the alwayson cluster resource and change the default from 1 failure in 6 hours...

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

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

  • RE: sql server migration

    do not restore the system databases, instead migrate the objects (login,jobs,etc)

    A direct attach\upgrade of the user databases to sql server 2012 is supported.

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

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

  • RE: SQL 2012 cluster downgrade to 2008 R2

    a clustered uninstall takes minutes to uninstall and is a clean way of removing the instance, you may then install your chosen sql server edition to re install.

    Running SQL server...

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

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

  • RE: Problems Installing SQL 2012 Cluster - System Volume Information error

    DB the DBA (10/28/2014)


    I could get around this by installing to a folder on the mount point instead of the mount directly.

    It's not a work around that's exactly...

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

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

  • RE: Preventing failover of active/active cluster

    mbricker-600840 (10/28/2014)


    In this case the entire netwrok may go down.

    Take the instances offline during this period then and keep the downtime short.

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

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

  • RE: Preventing failover of active/active cluster

    mbricker-600840 (10/28/2014)


    Yes we have a 5 hour downtime window, but needto stay up as long as possible. We are thinking of pausing the nodes so nothing can move, but we...

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

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

  • RE: SQL Server on NAS storage (NetApp Data ONTAP)

    jtheulier (10/28/2014)


    As we plan to dedicate an ESX for SQL Server, we decide to have a new storage type.

    The way i'm reading this is that you're going to dedicate a...

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

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

  • RE: Preventing failover of active/active cluster

    mbricker-600840 (10/28/2014)


    We are a hospital, so we need to minimize any issues.

    Any ideas on what we should do to protect ourselves.

    Thanks in advance.

    Ensure that any disconnections to the clusters public...

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

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

  • RE: Failover clustered instance with availbility groups

    SQLAssAS (10/28/2014)


    PROD Server 1 – Fixed storage, primary for High availability group, Automatic failover

    PROD Server 2 – Fixed storage, secondary for High availability group, read only copy

    DR Server 1 –...

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

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

  • RE: Unable to connect SQL server after master db restored

    Well, irrespective of where you think model is, the C drive is where the service is looking.

    Has this master db backup come from this server originally?

    Check the service startup parameters...

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

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

  • RE: Unable to connect SQL server after master db restored

    The error is pretty clear the model database cannot be opened.

    Check the path in the errorlog, is it correct, are the permissions correct on the folder?

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

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

  • RE: Availability Group Listener Port

    😉

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

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

  • RE: AlwaysOn - Is a fileshare witness really needed?

    bbcolo22 (10/27/2014)


    I am using Windows 2012R2.

    Ok, Windows 2012 and 2012 R2 have a new feature called Dynamic Node Weight configuration. During a planned outage such as a shutdown the quorum...

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

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

  • RE: AlwaysOn - Is a fileshare witness really needed?

    bbcolo22 (10/27/2014)


    I have seen many recommendations stating that if you have an even number of nodes, then you should create a fileshare witness (for the 3rd quorum vote). I would...

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

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

  • RE: Problems Installing SQL 2012 Cluster - System Volume Information error

    anthony.green (10/27/2014)


    Traditional lettered drives I believe.

    I didn't set the cluster up from a Windows perspective.

    You'd soon know when you run the installer by the free volumes offered and the shared...

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

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

Viewing 15 posts - 2,806 through 2,820 (of 9,241 total)