Forum Replies Created

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

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

    Wow as long as you think there's nothing wrong with it then fine, i'm glad it's not my IT budget you're spending 😉

    By Virtualising a single Vm on a single...

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

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

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

    Please detail exactly what you have done so far, maybe supply a screenshot

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

    "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)


    Yes it is correct, a whole ESX to answer to licensing needs.

    Thats what I was afraid of, if you get anywhere near giving all the host resources to...

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

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

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

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