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


ADVERTISEMENT

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 :: Can't Find Online To Setup AlwaysOn From Scratch

Apr 29, 2015

I am trying to setup alwayson on 2008r2 server on 2 instances in the same machine fort testing purpose. I installed 'Failover Cluster Manager' now I don't see 'Nodes' to add up.Should I run 'Validate a configuration Wizard'? or something else.. Can't find online to setup 'Alwayson' from the scratch...Will I able to setup 'Always on' on same server but different instances like mirroring? or has to be different servers?

View 5 Replies View Related

SQL 2012 :: How To Change Backup Replica In AlwaysOn Cluster

May 6, 2014

How can we change the backup replica in Always on Cluster. I am not able to take backup because of this.

View 7 Replies View Related

SQL 2012 :: AlwaysOn Backup Plans - Copy Only Backups

Jul 11, 2014

We have just implemented a SQL 2012 always on environment. We have a primary and secondary server. I am confused about how to set up the backup plans. The application team was happy to tell me that in sql 2012 always on we can offload the backups to the secondary, thus reducing overhead on the primary server.

However, the secondary only supports copy only full backups. I am unsure how these would be useful in a disaster event? I could not apply any trx log backups on a copy only backup. This means I need to run my full backups on the primary server?

View 7 Replies View Related

SQL 2012 :: VLFs On AlwaysOn Primary Replica After Log Backup From Secondary

Aug 6, 2014

I was working on a job to send me info each morning about database file free space and was noticing some odd things when looking at the log file VLFs for one of my databases in an AlwaysOn availability group.When I run DBCC LOGINFO on the secondary replica for this database, I get what I expect and most VLFs have a status of 0 (indicating the VLFs are reusable or unused). When I run DBCC LOGINFO on the primary replica, all of the VLFs have a status of 2 (active or recoverable).

Since log backups on the secondary replica in AlwaysOn still truncate the log in the primary replica, I would expect that the VLFs in the primary replica would also be mostly in a reusable or unused state. My log file sizes are the same size on each server and my backups are completing successfully. what might be causing the VLFs on the primary replica to have a status of 2 in DBCC LOGINFO when taking log backups from the secondary replica?

View 6 Replies View Related

Recovery :: AlwaysOn Setup For DR Plan

Aug 6, 2015

We have a client which they have production 2 node cluster environment. On it around 200 databases with single SQL instance.

Now client wants disatster plan for these 200 database. In these 200 database 3 db's are around 80 GB each databases remaing are less than 5 DB.Note: All these 200 db's are having produciton sites (i mean to say each db is having single site)

For this DR paln clinet is going to provide other DR server,they wants to setup DR between exsting produciton cluster instance to this DR server.

So in this case we have suggest SQL server AlwaysOn availability group.

Here my main question is can we keep all these databases in single AG? .If yes, guidlines to move up. if not, do we have any limitations.Also, best method to setup for this DR plan.

View 6 Replies View Related

AlwaysOn Setup Between Default And Named Instance?

Aug 25, 2015

Though to setup Alwayson, it is necessary to have both SQl Instances to be in same version, same database file path , etc.But, is this possible to setup the AlwaysOn between a default and a named instance?

View 1 Replies View Related

DB Engine :: Can Mirror A Database On Which AlwaysOn Is Already Setup

Jul 29, 2015

We have a database with AlwaysOn enabled, where the database is getting mirrored using AlwaysOn to a secondary node in a two node cluster. Now we want to set up a DR site for that database in a different data center.

So trying to analyse what technologies. We can use for setting up the DR for that database. Can we use mirroring / replication or what's the best way of setting up DR on that database.

View 3 Replies View Related

Recovery :: Monitoring AlwaysOn HA Setup With HyperV

Oct 29, 2015

I have configured AlwaysOn HA setup with HyperV environments without shared disk and using quorum voting in file share witness.

1. I want to monitor AlwaysOn HA setup and AO Group database on daily basis.
2. To configure email alerts for proactive monitoring if unusual events occur.

Scripts for monitoring in that AO setup as well as AO group database ...

View 8 Replies View Related

Recovery :: Multi Site AlwaysOn Setup With Different Subnet?

Nov 17, 2015

OS - Windows 2012 R2 Standard Edition.
DB - SQL 2012 Enterprise edition

Total 3 nodes participates for AO setup, 2 Nodes for Local HA and 1 Node for another datacenter for DR. All the 3 Nodes are same domain name and member.

1. Local First 2 Nodes are same subnet XXX.XX.44.XX
2. DR Node another subnet XXX.XX.128.XX

Does it require to add two different IP address while creating cluster name? Not using shared disk SAN storage etc.. I am using Node majority quorum witness setting for failover. 

View 10 Replies View Related

Recovery :: Setup AlwaysOn Availability Group Between 2 Separate Clusters

Sep 22, 2015

I have an active passive cluster on my primary Data center in NY and have a DR Active / passive SQL Cluster in TX. These are two separate clusters in the same domain using the same SQL server credentials.Both clusters host an active / passive SQL instance. Lets call it SQLNY(Primary) and SQLTX (DR). I want to enable always On Availability group within the two SQL Instances SQLNY and SQLTX. The listener will be SQLAG which will be used by the Application to connect to the SQL instance. Is there a practical way to implement this? This will not only give me instant fail over within the NY (Primary) but also give me the flexibility to fail over to TX. I am using SQL 2014 Enterprise Edition on both clusters.

View 6 Replies View Related

DB Engine :: Transaction Log Backup On AlwaysOn Databases

Jun 26, 2015

I am using alwayson on my SQL 2012 databases. I am using ola hallengren scripts for backing up databases. Full & diff db backups work fine, but the log is not getting backed up. The tran log backup job doesn't error out too. Trying to figure out what I may be missing?

View 10 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 Server Admin 2014 :: AlwaysON Secondary Full Backup?

Nov 12, 2014

Recently I have faced one DBA interview, below is the question they asked me.

" Does AlwaysON secondary replica support Full backup, if it is not why"?

I know AlwaysON secondary replicas support only copy_only and tlog backups, why they wont support full backup?

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

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







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