SQL 2012 :: AlwaysOn - Access Point For Administering?

Oct 5, 2015

Node 1 -IP Address 10.xx.xxx.11
Node 2 -IP Address 10.xx.xxx.12

while create cluster wizard in access Point for administering the cluster which IP address need to type Address filed? Does it Node1 IP to be type?

1. I have type Node 1 -IP Address 10.xx.xxx.11 in that filed but I Received error as below

You do not have permissions to create a computer object in the Active Directory

2. What type of permission is required that particular domain id which was logged both the nodes?

View 8 Replies


ADVERTISEMENT

AlwaysOn - Use Availability Group Listener Or Just Point To Cluster Name

May 6, 2014

I have MasterDataServices installed on a server and the database is in an AlwaysOn Availability Group.The MDM front end currently is set up incorrectly and is referencing NodeA (primary node) for its database.I want to fix this but im unsure if i should:

-point the MDM front end to the cluster name, so it wont matter what server the databsae is on?
-create an Availability Group Listner, which would also decoupple the database referenced from a particular server.

View 5 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 :: 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 :: 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 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

Many To Many With One Access Point Table

Jun 3, 2008

Hello,

First time poster.

I have a database design question. I just read the article on table inheritance but i still do not know if I'm doing this right.

Say you have an organizations table and a persons table like the ones below with a many to many relationship like these three tables:

Organization:
AutoId TaxId Name

Person:
AutoId FirstName LastName

OrganizationsPersons:
AutoId OrgAutoId PersonAutoId


Now the question is that an organization and a person both need to access the address table.

Is it better to have a PersonsAddress table and an OrganizationsAddress table, or is it better to have some sort of AddressAccess table that the persons and the organizations tables both relate to and have some sort of type field in there that specifies Org or Person?

Thanks ahead of time for any help.

View 7 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 :: 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

SQL 2012 :: Maximum Cluster Nodes In AlwaysOn

Mar 17, 2014

How many nodes can you have in a cluster with SQL 2012 alwaysOn.

I understand that availability groups are limited to 5 nodes but if you had a 10 node cluster and decided to create multiple availability groups using various nodes within the 10 nodes but never exceeding 5, is that possible?

Or is there a counter or some validation from SQL AlwaysOn that actually hard limits to a grand total of 5 nodes in a cluster?

View 6 Replies View Related

SQL 2012 :: Renaming AlwaysOn Availability Groups?

Apr 28, 2014

We had 3 Availability Groups set up in SQL 2012 last year but they were poorly named so I am just looking to rename them but there doesn't seem to be any command for it that I can find.Can they not be renamed once created? I guess I could just create new ones and move the DB's into them but just thought I would check!

View 1 Replies View Related

SQL 2012 :: AlwaysOn Read Only On 2nd Instance Server

Jul 18, 2014

Considering trying to move 2008 acitve/passive cluster with log ship to day old read only 2008 server to 2012 active/passive to 2012 AG Read only server. Only problem is that read only instance may have to be a 2nd instance on a server. The new box is a beast 64 core 256 gig of RAM hp so this is no dog. So I have these choices

migrate 2008 active/passive cluster to 2012 active passive (this will be it's own ordeal)take new monster box and build two instances, one that will run the AG read only database, the other will house reporitng services and analysis services and a few dw databases. We are not heavy into deep dive analysis services yet kind of in it's infancy. Not sure if this other instance will be sql 2008R2 , may be able to do 2012. MY also have a few small sharepoint databases but they barely use it.

View 3 Replies View Related

SQL 2012 :: AlwaysOn - Readable Secondary Option

Aug 21, 2014

In always on under availability group server name properties can see the option Readable Secondary. In that for secondary server the Readable Secondary Option is YES and for Primary it is Read-Intent. I believe Read-Intent allows only read only connections and YES allows all user connections.

View 0 Replies View Related

SQL 2012 :: AlwaysOn - Readable Secondary Options

Aug 21, 2014

In always on under availability group server name properties can see the option Readable Secondary. In that for secondary server the Readable Secondary Option is YES and for Primary it is Read-Intent. I believe Read-Intent allows only read only connections and YES allows all user connections.

What exactly it means for the primary and secondary?

View 3 Replies View Related

SQL 2012 :: AlwaysOn AG Replicating Much Slower Than Mirroring

Sep 30, 2014

I'm setting up AG replication over our WAN (1GB MPLS). Using sql stress, AG replication quickly falls behind. Network throughput plateaus at ~14Mbs.

The problem ISN'T NETWORK

using conventional mirroring, the same workload never falls behind, throughput plateaus at ~26Mbs.

it's almost like log stream compression isn't happening for AG...

both mirroring and AG are using async.

View 4 Replies View Related

SQL 2012 :: Make AlwaysOn Over Normal Cluster

Nov 13, 2014

Can we make SQL 2012 Always ON over the normal SQL Cluster 2012.

View 3 Replies View Related

SQL 2012 :: AlwaysOn Failover Due To Missed Heartbeats

Dec 10, 2014

I have setup SQL AlwaysOn between primary and DR data centers. Here is the setup:

Primary data center: Server1 (Primary), Server2 (Sync Commit Secondary), Server3 (ASync Commit Secondary)

DR data center: Server4 (ASync Commit Secondary)

Data synchronization and manual failover works fine. But, sometimes, the AlwaysOn cluster automatically fails over to Sync Commit Secondary on Primary data center. Here is the error message from Failover Cluster Manager->Cluster Events:

"Cluster has missed two consecutive heartbeats for the local endpoint xx.xx.xx.yy:~3343~ connected to remote endpoint xx.xx.xx.zz:~3343~"

"Cluster has lost the UDP connection from local endpoint xx.xx.xx.yy:~3343~ connected to remote endpoint xx.xx.xx.zz:~3343~"

I had our network engineer check all connections multiple times and he confirmed everything is fine. But he was also able to confirm (using monitoring tools) that right at the time of a failover, there is almost 2GB worth of traffic going from Primary Server to DR server. That happens every time. I had checked the times of all failovers and there is no job or process occuring that will produce 2GB worth of data. Also, this happens regardless of which server is primary.

Even though the failover works fine, this unexpected automatic failover due to missed heartbeats are occurring often (2-3 times a month).

Here is the list of errors from the Cluster Validation Report:

Under Network Section, I see the following error messages in Red:

Validate Network Communication

Network interfaces Server4 (DR) - SAN_Team and Server1 (Primary) - SAN_Team - VLAN 20 are on the same cluster network, yet address xx.xx.xx.pp is not reachable from xx.xx.xx.yy using UDP on port 3343.

Network interfaces Server4 (DR) - SAN_Team and Server2 (Secondary) - SAN_Team - VLAN 20 are on the same cluster network, yet address xx.xx.xx.qq is not reachable from xx.xx.xx.yy using UDP on port 3343.

[Code] ....

View 7 Replies View Related

SQL 2012 :: AlwaysON Linked Servers Failover

Jan 27, 2015

So I have 2 servers S1 & S2.

Database Group 1 = L1 with Primary S1 and Secondary S2
Database Group 2 = L2 with Primary S2 and Secondary S1

For 99% of the time the 2 groups of databases are not related. For the 1 procedure that does move data from L1 to L2 something like

Update L2.DB.Owner.Table
set flag = 1
Whare a = 0

On S1 I have a linkedServer with connection to L2.

If I have a failover I cannot have L2 on S2 as they are essentially the same server.

How to I use the 2 groups hand in hand.

View 0 Replies View Related

SQL 2012 :: Log Management Of Primary Database In AlwaysOn?

Mar 1, 2015

In always on docs in msdn they mention only about backup of secondary.. explain the backup of primary or how logs are managed in primary database. My doubt is a normal database in full recovery mode the log file will grow if we didnt take proper log backup,how the same is managed in primary in Always On.

View 2 Replies View Related

SQL 2012 :: AlwaysOn Database Not Synchronizing / Suspect

Mar 2, 2015

We have a database in an AlwaysOn Availability Group that has gone into a state of Not Synchronizing / Suspect on the secondary.

The reason why this happened is because the secondary ran out of disk space so the log file wasn't able to be written to. The database was set to synchronous mode.

Is the only way to recover from this to do a re-initialization or is there another way to recover?

View 2 Replies View Related

SQL 2012 :: Advantages Over SERVER AlwaysOn Over Clustering

May 14, 2015

Give the Advantages Over SQL SERVER Always on over Clustering....

View 4 Replies View Related

SQL 2012 :: Setup AlwaysOn On Existing Cluster?

May 19, 2015

We have an existing SQL Server 2012 Enterprise cluster with 2 nodes (active-active) and uses Windows 2008 R2 OS. We are looking for a way to increase HA as well as offload backups to secondary server and it was suggested that AlwayOn could be an option.

The questions I have are:

1) Is it possible to turn on AalwaysOn feature on an existing cluster?

2) If yes to above, does the secondary replica need to exist as a node on the same cluster or can it be on a completely different cluster?

3) If the secondary replica is on the same cluster (i.e. we add a 3rd node to existing 2 node cluster), can that node be provisioned with storage from a completely different SAN? (i.e. Node 1 and Node 2 accesses LUNs on SAN1 and Node 3 accesses LUNs on SAN2).

View 9 Replies View Related

SQL 2012 :: Error At Adding Listener For AlwaysOn

Jun 11, 2015

I am trying to setup an AG on a cluster, I was able to define where I want my replica, but I need to setup the ip for the listener of that one

When I am adding the Ip at the listener I am getting the following message:

The Windows Server Failover Clustering (WSFC) resource control API returned error code 5057. The WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. For information about this error code, see "System Error Codes" in the Windows Development documentation.

The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator. (Microsoft SQL Server, Error: 41009)

Browsing around I found this guide: [URL] ......

And I make sure that the cluster has permissions to "Read all properties", "Create Computer Objects", even to "Create all child" permissions

I also added those permissions to the account that starts sql at that cluster and I am logged as that and I am still getting the error....

View 4 Replies View Related

SQL 2012 :: AlwaysOn Availability Group Per Database

Jun 26, 2015

We are planning to upgrade our production servers from mirroring to alwayson. Our current mirror setup gives the advantage that it can failover a single database.To have a similar setup in alwayson we are probably going to create an availability group per database. Any other disadvantage in this except for the extra initial configuration work?

View 9 Replies View Related

SQL 2012 :: AlwaysOn Multiple AGs And Listeners In Same Instance

Jul 9, 2015

Currently we have an AlwaysOn AG set up with a listener running on port 1433 (underlying instances are on a non default port). Great, no problems there.If we set up a second AG on the same instance with its own specific listener, can this new listener also be configured to use port 1433?

View 2 Replies View Related

SQL 2012 :: Configure AlwaysOn Between Two Different Network Section?

Jul 29, 2015

How to configure AlwaysOn between two different network section?

View 2 Replies View Related

SQL 2012 :: Maintain Indexes When AlwaysON Is In Place

Aug 4, 2015

I have a new cluster (2 sync, 2 async) with about 50 databases going from 1 to 200gb ( all of the objects are compressed).That at sql server 2012, sp1 CU7.I have several drives for logs with 200gb of space in there...I am having issues at rebuilding indexes on this env, ie, I have a table with the clustered index heavily fragmented (~80%), and the table has about 60gb of data, uncompressed that should be about 160gb.

The index rebuild is creating a log file big enough as to consume all the space that I have for logs, and that is only 1 table, so for sure my old process to maintain indexes (ola.hallengren code) won't work on this scenario.

View 8 Replies View Related

SQL 2012 :: Re-index With AlwaysOn Availability Groups

Sep 15, 2015

We have multiple SQL 2012 SQL servers setup in an alwaysOn availability groups. Where should we schedule the re-index? We have Server1 as the primary and 2 secondaries Server2 and Server3. Are their any tricks to have it run on which ever one is the primary?

View 1 Replies View Related

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







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