Forum Replies Created

Viewing 15 posts - 2,971 through 2,985 (of 9,241 total)

  • RE: Sql Server File Placement

    if you're unable to split tempdb log from tempdb data files they should go on the same drive, this is also the default offered in the sql server installer

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

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

  • RE: Add node in a cluster -- Network configuration issue

    gary1 (9/8/2014)


    Hi ,

    I have installed SQL Server 2012 on Node1 successfully and trying add node on Node2 and its failing with below message. Please advise. I attached the screen shot.

    Here...

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

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

  • RE: Building Microsoft cluster in VM VS using VMware vmotion

    Clustering guest machines does indeed pose some restrictions when you use shared storage. In a stable virtual infrastructure, I would be more inclined to rely on VMWare DRS and VMotion...

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

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

  • RE: Is it *possible* to build a *three* node SQL Server 2012 cluster on VMware virtual machines?

    shew (9/8/2014)


    We are getting mixed information from various sources while researching the possibility of creating three node SQL Server clusters on VMware virtual machines.

    Is it *possible* to build a *three*...

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

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

  • RE: Error 18456: Login failed for user '<user_name>'

    par.anthony (9/5/2014)


    machine, or from my application code.

    The error I get is 'Login failed for user '<user_name>'

    please supply the state and severity id from the error message

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

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

  • RE: Log shipping planned failover with mirroring configured.

    dinsab11 (9/6/2014)


    I have log shipping and mirroring configured, now I need to failover (planned) log shipping. is there best steps to follow and keep mirroring in sync?

    Yes there are steps...

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

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

  • RE: Destroy cluster

    Scorz (9/5/2014)


    So I can evict the passive node from the sql and windows cluster and re-install a stand alone instance on the former passive node?

    If you evist the node the...

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

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

  • RE: Destroy cluster

    Scorz (9/4/2014)


    We have an active\passive cluster that needs to be dismantled but we want to keep the SQL instance. Can I just remove each node from the sql cluster...

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

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

  • RE: Changing server, user name and password

    changing the computer name will essentially change the sql instance name, this is likely the issue you are having. Supply the new servername or the IP address and retry the...

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

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

  • RE: Transaction Log Full

    sounds like the log is not large enough to cope with the longest active transaction 😉

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

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

  • RE: upgrade 2012 from 2008 to add to always on solution

    do you want the AlwaysOn solution to reatin a failover cluster instance as a replica? There are restrictions by doing this 😉

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

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

  • RE: upgrade 2012 from 2008 to add to always on solution

    an upgrade is perfectly viable as long as it's between supported editions. What is the state of each node for cluster membership? Is the current instance a Failover Cluster Iinstance...

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

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

  • RE: Is there a way to change the IP address of SQL Server which is locally hosted and is not on cluster?

    do you plan to use separate NICs or one NIC?

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

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

  • RE: Master Database on new SQL Server Instance

    bpowers (9/3/2014)


    We created a new SQL Server instance, on a new virtual machine, to replace one of our servers that has a production instance of SQL Server. On the new...

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

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

  • RE: Changing NAME and IP ADDRESS of machine where SQL Server is hosted.

    if running under local system you shouldnt need to do anything

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

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

Viewing 15 posts - 2,971 through 2,985 (of 9,241 total)