Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 9,244 total)

  • RE: Monitor AG Listener Remotely

    salamlemon (7/28/2015)


    Hi Guys,

    I need to check connectivity to AG listener remotely and log that to a table/file. What is the best way to do that? Powershell?

    You'll want to check the...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Clustered instance uninstall

    shawnjohnson (7/24/2015)


    I have started the process to remove a node from the cluster under Maintenance of the Installation center. I can select the instance so setup can see it...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Installing failover cluster instance side by side to a standalone installation with alwayson

    qur7 (7/23/2015)


    Hello All,

    would like to know if it's possible to install SQL Server Failover cluster instance with shared storage along with standalone installation with Always on ( always on uses...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: One Node could not up in SQL Server Failover cluster

    keshab.basnet (7/23/2015)


    But we are facing when one Node is restarted. We could not restart that Node in cluster Service start in Failover cluster Manager.

    The cluster service should automatically restart on...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: upgradingSQL 2008 R2 active\active Cluster to SQL 2014 cluster

    FTdenali (7/24/2015)


    Now I need to know if I can do a straight in place upgrade without having to first upgrade to SQL 2012 and then upgrade to SQL 2014.

    What edition...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Failover Cluster and Always ON with non standard configuration, hot to configure the failover?

    the resource possible owners are set and managed by the availability group to cluster integration. You should not touch or change these

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Application connecting to AG Listener static IP address - not name

    ian.procter (7/22/2015)


    Our Contractor has configured the Application’s connection strings to connect to the two Static IP addresses assigned to the AG.

    Connecting to the DNS name would resolve any IP connection...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: AlwaysOn transaction log filling up

    check that none of the secondaries have suspended data movement, open the availability group section and drill down to the secondary database(s). Look for a little pause symbol instead of...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: WIndows server 2012 R2 Failover Cluster and SQL Server 2012 Failover cluster

    why don't you try google and search for "create msdtc cluster resource 2012"??

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: DB mirroring transact-SQL error 1418, SQL Log error 1433 severity 16 state 2

    check the endpoints to make sure theyre started

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Error installing SQL Server Database Engine Services Instance Features o

    when setup fails it gives you the path and name of the log file πŸ˜‰

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: SQL 2014 AlwaysOn vs AlwaysOn+FCI

    ItsDaveTime (7/22/2015)


    I've worked with clusters (active/active, active/passive) and AlwaysOn. I've read about using AlwaysOn + FCI, but am not quite grasping what adding FCI provides me with AlwaysOn.

    With...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: DB mirroring transact-SQL error 1418, SQL Log error 1433 severity 16 state 2

    rcaballero (7/22/2015)


    every time I run the ALTER..SET PARTNER on the PRIMARY, I get these logged under the SQL Logs

    - Database mirroring has been terminated for database 'DBName'. This is an...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Error installing SQL Server Database Engine Services Instance Features o

    what's in the log produced by setup?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: DB mirroring transact-SQL error 1418, SQL Log error 1433 severity 16 state 2

    looks ok initially, any other errors in the event logs or sql logs

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 1,861 through 1,875 (of 9,244 total)