Forum Replies Created

Viewing 15 posts - 601 through 615 (of 9,244 total)

  • RE: SQL Server geo-cluster 2016

    hurricaneDBA - Tuesday, August 1, 2017 12:42 PM

    A clustered node uses FCI correct or is the cluster using AGs?

    I thought we'd...

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

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

  • RE: SQL Server geo-cluster 2016

    hurricaneDBA - Tuesday, August 1, 2017 10:18 AM

    No 1 WSFC spanning two locations with one sql server node in each location. Is...

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

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

  • RE: SQL Logins from 2005 to 2012, but also to new domain.

    Duran - Monday, July 31, 2017 8:46 PM

    Hi everyone,

    I wondered if someone might lend me a bit of advice based on their...

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

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

  • RE: Any known issues with in-place upgrade of a 2 node 2012 AG to 2016?

    Mick Opalak - Friday, July 28, 2017 12:45 PM

    I have a 2 node, SQL 2012 AG running in asynchronous mode.  I will...

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

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

  • RE: SQL Server geo-cluster 2016

    hurricaneDBA - Monday, July 31, 2017 3:40 PM

    Implementor was planning on creating 2 sql server clusters with each cluster having 2 nodes...

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

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

  • RE: Allow remote SQL connections from specific IP addresses via windows firewall?

    6 year old post!

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

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

  • RE: A network-related or instance-specific error occurred while establishing a connection to SQL Server

    3 year old post

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

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

  • RE: Automate SQL Server Installations

    Thom A - Monday, July 31, 2017 2:32 AM

    There isn't really much to the PoSh side of things. The main thing you...

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

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

  • RE: After sql upgrade from sql 2014 to sql 2016 failover on 2 node windows cluster fails

    JP10 - Thursday, July 27, 2017 10:30 AM

    Hey Perry,
    I basically ran Data Migration Assistant first on the active node, then ran the...

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

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

  • RE: SQL Server 2014 AlwaysOn failover

    shawnshine - Tuesday, July 25, 2017 7:50 AM

    Hi Perry,

    Yes, you are right. The databaseNumber2 fails to move to the replica DB3 and...

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

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

  • RE: After sql upgrade from sql 2014 to sql 2016 failover on 2 node windows cluster fails

    JP10 - Monday, July 24, 2017 5:05 PM

    I have a 2 node windows cluster set up.  node 1 (active node) fails to...

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

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

  • RE: Proper Process for Adding Node to SQL Server 2012 Failover Cluster

    lmarkum - Wednesday, July 26, 2017 12:23 PM

    We have a SQL Server FCI that some time ago was converted from physical to...

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

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

  • RE: After sql upgrade from sql 2014 to sql 2016 failover on 2 node windows cluster fails

    JP10 - Wednesday, July 26, 2017 11:05 AM

    @perry,

    I ran the command you posted and noticed that the "SQL Network Name ()" only...

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

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

  • RE: SQL Server geo-cluster 2016

    hurricaneDBA - Thursday, July 27, 2017 12:26 AM

    So correct me if I'm mistaken AlwaysOn needs WSFC and being on nodes and with...

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

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

  • RE: "Network-related or Instance specific error" when connecting through SSMS

    bmg002Since you can connect when you specify the port, I am thinking this isn't a firewall related issue.

    If you can only connect when specifying the instance port it's completely and...

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

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

Viewing 15 posts - 601 through 615 (of 9,244 total)