SQL 2012 :: AlwaysON Setting Up A C Node?

Apr 28, 2014

I have an A & B node set up and running. I now want to add a C NODE.

The catch is the C NODE is in a SQL Cluster Environment.

I am guessing I add the Virtual Name of the C node to the current Always ON Cluster?

I tried adding it...the error message says" the Virtual Node is really the A node and to add the A NODE"?

View 6 Replies


ADVERTISEMENT

SQL 2012 :: Using VMotion To Migrate AlwaysOn Node

Nov 4, 2015

Our network guys have to carry out an IBM Flex Chassis move at our data centre, which will affect the primary replica of one of our SQL 2012 AlwaysOn Availability Group nodes (the secondary replica won't be affected).

They have suggested using vMotion to migrate the primary replica to another virtual host, which will result in a very brief period of network outage for the node.

I've done some reading and have seen a few potential issues regarding Stun During Page Send (SDPS) and increasing thresholds within WSFC. Unfortunately, we're not able to test this prior to the migration, so I have a few questions...

Would it be necessary to failover to the secondary replica node before performing the vMotion (and back again afterwards)?

View 0 Replies View Related

SQL 2012 :: AlwaysOn Secondary Node Slower Than Primary

Oct 3, 2014

I have a SP that runs on the primary in 18 min and 45 min on the secondary( poorly written cursor,trying to fix it).Both machines are Exactly the same.I ran them in the middle of the night when no one was on the Sec. Node as we use it for reporting.

PLE: 7,000+
AVG Disk sec/write below .01
AVG Disk sec/read below .01
CPU below 5%
both machines set a max dop 4

View 2 Replies View Related

SQL 2012 :: AlwaysOn Availability Group Listener DNS Resolving To DR Node

Jan 19, 2015

We are rolling out the use of Availability Group listeners to our SQL Server 2012 Environment which has a 2 node multi-subnet cluster. The Primary is R/W and the Secondary is a non-readable node that would be manually failed over to in a DR scenario

I have set up the AGL and asked the sysadmins to create a DNS record in both subnets with fixed IP's.

The issue I have having is that when I ask the app developers to connect to the databases using the AGL it is totally random whether the AGL resolves to the Primary or DR node - as a result that are having problems getting their apps to connect.

I was thinking of asking the sys admins to remove the DNS record in the DR subnet and then add it back in should we need to fail over - but I was thinking there must be a better way.

View 3 Replies View Related

SQL 2012 :: Setting Log Shipping In AlwaysOn Environment

Jan 23, 2013

We have 4 Servers which have SQL SERVER 2012 and "AlwaysOn" have been enabled on all 4 servers:

Server1,Server2,Server3,Server4

Server1 is the Primary node and thr rest are secondaries. There is a Sync relation between Server1 and Server2 and also there is aSync relation between Server1 and Server3 & Server4.

Is it possible to setup log shipping from Server2 & Server3(secondaries) to two new servers?

View 9 Replies View Related

SQL 2012 :: Log Shipping - Reboot Secondary Node And Then Primary Node

Apr 20, 2015

I have not used log shipping before and find myself in a position where I need to reboot the secondary node and then the primary node and I don't actually need to failover.

Is there anything I need to be aware of. When rebooting the secondary node I assume the transactions will be held in the primary nodes log till the secondary comes back and just carry on once back up?

When rebooting the primary node nothing needs to be done and the log shipping will just start again once it has come back?

View 3 Replies View Related

AlwaysOn Connection With Primary Node Using Its Host Name

Feb 26, 2015

I have set up a 2 node availability group to take advantage of using the secondary node for a read-only replica. I actually am having two issues. The first being I can connect to the primary node using the listener dns name and ip address, but no longer can connect via its actual host name or ip address. I can ping the address with no problem, but I can't connect to port 1433 using the actual host name or ip address.

I am no problem connecting to the secondary node using its host name, but can not get to it through the listener using the applicationintent=readonly. Eventually I would like for everything to connect through the listener name, but for now still need to connect via the server's host name and don't understand why; everything I read is that the primary node should be able to be connected via both the host name and the listener name.

View 9 Replies View Related

3 Node 2014 AlwaysOn - Automatic Failover?

Jun 30, 2015

I have a 3 node 2014 AlwaysOn setup. The primary and secondary are set for automatic failover. The third node, of course, is manual (until 2016). The 2 nodes with are automatic are sitting in one datacenter, the third is in another. If the first datacenter was to go down, I would manually have to failover to the third node? What's the normal process here for having two datacenters and ensuring the availability group is always available?

View 3 Replies View Related

Recovery :: Add Second Node In AlwaysOn Availability Group

Aug 13, 2015

How do I add my second (secondary) node in my AlwaysOn Availability Group, after adding my head node, and the secondary node is a virtual machine. See based on the attached file if it is the correct way?

View 2 Replies View Related

SQL 2012 :: Running 2 Distinct AGs On Each Node Of A Two Node Cluster?

Oct 23, 2014

I'm contemplating running two availability groups on a two node WSFC. The WSFC is setup with a file share witness (i.e. no shared storage). Can I safely run 1 AG on one primary node, and the other AG on the other node (as primary). Each AG would have replicas on the passive node. This would effectively allow both servers to be in use at the same time. In a failover event, I understand that both workloads would transfer to a single server - so the box needs to be sized appropriately.

View 1 Replies View Related

SQL 2012 :: 3 Node Cluster Runs With 2 Node Failures?

Jun 11, 2015

We are in the process of building a 3 node SQL Server Cluster (Server 2012/ SQL Server 2012), and we have configured the quorum so that all 3 nodes have a vote (no file share witness as we already have an odd number of nodes).

As I understand it, this should allow the cluster to run as long as 2 of the nodes remain online.

However, the validation report states that 2 node failures would be acceptable and, when we tested this by powering off two of the nodes, the cluster did indeed continue to run on a single node.

View 4 Replies View Related

Recovery :: Windows 2008 R2 AlwaysOn Cluster - Migrate DR Node

Oct 8, 2015

I have a Windows 2008 R2 Always on Cluster with 3 nodes (two in the primary site and one in the DR site).

Primary Site:
     -Primary Site Server1
     -Primary Site Server2

DR Site 1 (to be decommed):
     -DR Site Server1

Our company is planning on decommissioning the DR site.  But before we do this, we want to add a 4th site to the cluster.  Migrate the data...and then decommission the original DR Site.

Is it possible to have this configuration:

Primary Site:
     -Primary Site Server1
     -Primary Site Server2

DR Site 1 (to be decommed):
     -DR Site Server1

DR Site 2 (NEW DR Site):
     -DR Site Server1

IF this is possible, do I simply add the new DR site to the existing cluster (same steps as adding the first DR node to the cluster when the cluster was originally configured?  or are there special steps?

View 2 Replies View Related

SQL Server Admin 2014 :: AlwaysOn - Amount Of Data To Move To Replica Node

Aug 4, 2015

Background information: SQL 2014 Ent. highly volatile OLTP environment. We generate 10 - 12 GB compressed transaction log backup files every 15 minutes.

Currently - we have two-node A/P cluster residing on flash array. Need to leverage AlwaysOn to offload processing. Replica server with have Flash storage. Replica node has same CPU and memory footprint. 10GB connection between nodes. Anyone generating such large transaction log for 15/30 minute time period?

View 0 Replies View Related

SQL Server Admin 2014 :: Handling AlwaysOn Failover And Failback To Preferred Node?

Aug 25, 2015

I am running SQL 2014 2-node AlwaysON Availability groups, Enterprise Edition in our environment and 5 databases are part of AG.

Question is, sometimes AG is getting failed over to node2 but always our preferred node is node1 due to some business needs otherwise some of our jobs will fail.

So, what I looking for is, a sql script which can handle a situation wherein, for some reason, AG is failed over to node2, it should be able to detect if node1 is back online or not and if so, it should fail back to node1. How to do this using tsql query or stored proc or sql agent job ?

View 4 Replies View Related

Recovery :: Change Authentication Mode From Windows To Mixed / 4-node Participating In AlwaysOn

May 13, 2015

I need to change the authentication mode from 'windows' to mixed, its a 4-node participating in always-on... Will this brake/impact alwayson in any way? I know I have to restart the sql instance.

View 3 Replies View Related

Recovery :: AlwaysOn - Changing Log File Growth Setting

Aug 5, 2015

I was looking to change the file growth setting in our AlwaysOn environment databases.We have a single availability group, one primary and one secondary replica. I learned that when changing the file growth setting on the primary databases (data file), the change flows though to the database on the secondary replica.However after doing the same with the log files, the file growth setting changed on the primary but the change did NOT propagate to the secondary.

Is the solution to apply the change directly to the secondary?here's the T-SQL code I used:

ALTER DATABASE myDB
MODIFY FILE ( NAME = N'myDB_log', FILEGROWTH = 512MB );
GO
SQL Server 2012 (11.0.5532)

View 9 Replies View Related

SQL 2012 :: Getting Value From XML / Node Out Of Table

May 16, 2014

I have a table which has a field with a data type of Xml. A sample record might contain something like this:

<?xml version="1.0" encoding="utf-16"?>
<order>
<Product Index="14c9643f-63d9-40c5" ProductID="13" Name="............>
<Attribute Name="Paper" OptCatId="1" Value="72" ....../>
<Attribute Name="Ink" OptCatId="2" Value="6" ......../>
<Attribute Name="Bleed" OptCatId="3" Value="15" ......./>
<Attribute Name="Number of Drops" OptCatId="0" Value="1" ...../>

I need to grab the Node/Attribute with the name of "Number of Drops" and get the value of "Value". So in this case, I simply want to get "1". How could I do this?

SELECT "value of Number of Drops"
FROM myTable
WHERE ID = ....

View 1 Replies View Related

SQL 2012 :: AlwaysOn Pending Changes

Aug 18, 2014

How to find the pending transactions to be applied on secondary in Always On? Can i get those details from dashboard?

View 2 Replies View Related

SQL 2012 :: AlwaysOn A/G Across Two Clusters

Oct 22, 2014

We are looking to setup an AlwaysOn A/G between two SQL instances across two SQL clusters - one cluster has two nodes the other has three nodes.

Is this possible using WSFC? Does the A/G wizard just handle this?

View 3 Replies View Related

SQL 2012 :: Add Node To Server Cluster

Oct 3, 2015

Can I add a new node to an existing sql server 2012 cluster witthout stopping all the current resources?

Currently, there are 2 nodes and 3 sql server instances, which can not be shutdown. Is the process of adding nodes a "online" process?

View 1 Replies View Related

SQL 2012 :: Backup Setup With AlwaysOn?

May 13, 2013

I'm setting up my first pair of Sql 2012 servers using AlwaysOn. I set up backups to run on the primary and I understand that you can set up backups to run on both the primary and secondary servers but the secondary will fail. Is there a way I can stop the secondary server from sending out error messages about failed backups? Is it possible to script it so that the server looks at whether it's primary or secondary and turns on or off alerts based on that?

View 8 Replies View Related

SQL 2012 :: AlwaysOn With Clustered Disks

Mar 13, 2014

I am trying to build the 2 node 2 clusters with the AlwaysOn.

Here isthe landscape.

2 nodes PROD failover cluster (running once instance)
2 nodes DR failover cluster (running 2 instances - DR and PRE-PROD)

Both clusters are in different geographies.

PRE-PROD can be editable. So out of scope of Always On.

One instance on PROD -> DR of the other box. [Want to achive thru AlwaysON]

Now my Question:

1) Do i need to have all the 4 nodes in same failover cluster group? If yes, then this would become MultiSubnet cluster Or Is there any way those 2 diffrerent failover clusters (one DR and one PROD) can be part of AlwaysOn.

2) Can i use the clustered disks as in the above landscape for always on?

View 1 Replies View Related

SQL 2012 :: Creating 2 AlwaysOn Clusters For 1 App

Apr 11, 2014

We have 2 SQL 2012 servers. Our application has 2 databases. We are creating an AlwaysOn cluster. Is it good to create 2 AlwaysOn clusters to have 1 database primary on one of the servers and the other database primary on the other server?

I have been asked if it is possible to have one database running on one server and the other database on the other server. Is this possible without creating 2 separate AlwaysOn clusters?

View 4 Replies View Related

SQL 2012 :: AlwaysOn Two Secondary Replicas

Apr 14, 2014

While configuring SQL Server 2012 Cluster with Always on, why do we need two secondary replicas.

The attached link will describe the actual query. [URL] ....

View 2 Replies View Related

SQL 2012 :: What Are Differences Between AlwaysOn And Clustering

Apr 24, 2015

What are differences between always on and SQL Server Clustering

View 1 Replies View Related

SQL Server 2012 :: Read All Values From XML Node?

Nov 21, 2013

I have the following code and trouble reading values of Bank Accounts. If i remove the line it says "xmlns="http://applications.apch1.com/webservice/schema/" then i my query is working. But i cant remove this becasue that is what i will get response from a web service. All the records are stored in the database with this line included.

DECLARE @MyXML XML
SET @MyXML = '<GetEmployeeDetails xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<return xmlns="http://applications.apch1.com/webservice/schema/">
<CustomerID> A8339 </CustomerID>
<BankAccounts>

[Code] .....

View 2 Replies View Related

SQL 2012 :: Add Node In A Cluster - Network Configuration?

Sep 8, 2014

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

Here we are not doing multi-subnet failover clustering. Why we are getting extra and asking for IP and what IP should we enter there?Add Node option should automatically detect the IP we configured on Node1.

[Error Message] To support SQL Server multi-subnet failover clustering, you must select at least one valid IP address for every subnet in the cluster.

[Details] Microsoft.SqlServer.Configuration.Cluster.ClusterIPAddressPublicValidationException: To support SQL Server multi-subnet failover clustering, you must select at least one valid IP address for every subnet in the cluster.

View 1 Replies View Related

SQL 2012 :: Extracting Node From A Column In A Table That Contains XML

Dec 4, 2014

I am trying to extract what I believe is called a Node from a column in a table that contains XML. What's the best way to do this? It is pretty straightforward since I'm not even looking to include a WHERE clause.

What I have so far is:

SELECT CCH.OrderID, CCH.CCXML.query('/cc/auth')
FROM tblCCH AS CCH

View 3 Replies View Related

SQL 2012 :: Two Node WSFC On A Multi Subnet

Feb 10, 2015

We are running SQL Server 2012 Enterprise on Windows 2012 R2. We have set up A WSFC with the primary Node in our East Coast Data Center and the Secondary Node in our West Coast Data Center each node is in a dfferent subnet. Since we have high latency between the sites we run in Asynchronous mode with manual failover only. My quesion concerns Quorum, everything I read would indicate we need a third node (odd number) (e.g. a fileshare Witness) with only the file share and the primary node having a vote...What I don't see is any need for a file share if we can only do manual failover.

View 7 Replies View Related

SQL 2012 :: SSISDB On New Primary Node Is Not Usable

Mar 6, 2015

During the installation of the SSISDB in SQL 2012 AG, the password used to encrypt the database was not preserved. Now when the server is failed over, the SSISDB on the new primary node is not use-able.Document the password and decrypt after using the master key after failover.

View 5 Replies View Related

SQL 2012 :: Cluster With Multiple Instances On The Same Node?

Jul 14, 2015

What I have- Sql server 2012 (Standard Ed) Cluster on Windows 2012 R2 with both instances running on the same node- just to save on License, i.e. technically it’s Act/Pas cluster.

What I am looking for- how to configure cluster (e.g. via quorum, etc) to force both instances failed together? Means if for some reason 1-st instance will fail to node 2 another instance should follow (otherwise it will be Act/Act cluster and 2-nd license is required).

If there is no standard way (cluster configuration I mean) to do it I should create some custom process to monitor where each instance is running.

View 3 Replies View Related

SQL 2012 :: WSFC Service Not Started In Second Node

Oct 21, 2015

I have configured Alwayson HA setup as following environment and versions, and working fine to client side by connected with AG Listener.

Two Node WSFC setup. Node1 (Primary), Node 2(Secondary Replica). Normal quorum(Not shared disk)

Server Platform: HyperV
OS: Windows server 2008 R2 64 bit with SP1
RDBMS: MS SQLSERVER 2012 64 bit with SP2

when I am doing testing Failover method between two nodes. automatic failover not happened.

Just shutdown Node1 and try to connect at client side by using AG Listener name but not succeeded, also Cluster name and AG Listener name are not pinging, Second node2 cluster service is not started by automatically due to as below errors. So how will connect client and overcome this issues? Any modification need to be done on both side WSFC and AlwaysOn SQL? for achieving and automatic failover.

Cluster network 'Cluster Network 1' is partitioned. Some attached failover cluster nodes cannot communicate with each other over the network. The failover cluster was not able to determine the location of the failure. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapter. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.

Client side got connected once Node1 get started again also cluster services started.

View 1 Replies View Related

SQL 2012 :: AlwaysON Availability Groups And Listeners

Feb 13, 2014

I have four instances and each instance have its own Availability Group with its own listener.

Would like to know if you can have one listener for multiple Availability groups?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved