Stack Overflow
Stack Overflow

Questions tagged [alwayson]

High-Availability and Disaster Recovery functionality, for SQL Server 2012 and later. A primary read/write database and up to 4 secondary database for reporting or disaster recover. There are several fail over and configuration options

196 questions
0
votes
0 answers

Why FC going down when primary node shutdown

I have an alwaysOn AG with 2 node: Primary node :192.168.66.2 Secondary node :192.168.66.6 Cluster IP:192.168.6.3 Listener IP:192.168.66.10 FileshareWithness I create cluster with 2nodes in primary server Now my problem is if primary sever…
memo
  • 15
  • 1
  • 6
0
votes
1 answer

Log Shipping from Synchronous Automatic Failover AlwaysOn Availability Group AAG

I have an AlwaysOn Availability Group which is running with Synchronous Commit & Automatic Failover. For example, connected to as SQL01 with nodes SQL01A or SQL01B. I want to make this data available for Warehousing on another server SQL02, due to…
Ryan
  • 43
  • 1
  • 7
0
votes
1 answer

Create an Availability Group Listener in SQL Server AlwaysOn Availability Group

I'll try to be as clear and concise as possible. I really hope someone can help me I have wasted a lot of time with this because I am not into infrastructure stuff. Goal: Configure AlwaysOn with two SQL Server instances, connect to the database…
freethinker6
  • 301
  • 3
  • 12
0
votes
0 answers

SQL Server Always On + changing Isolation level of SPID

Is there any reason why I cannot change the isolation level of a spid running against a primary database in an always on configuration? Scenario: we are running CRM Dynamics upgrade tool. It was being blocked when trying to run the following command…
JD_Sudz
  • 194
  • 1
  • 12
0
votes
1 answer

Why zoneminder monitor function utilizing camera constantly even when no one is monitoring

My IP camera has a LED which blink when someone is streaming from it. When I add the camera to zoneminder as monitor function, the LED keeps blinking constantly meaning zoneminder is streaming from it. It also keep blinking even when nobody is using…
R.J
  • 396
  • 1
  • 13
0
votes
1 answer

Adding database file (mdf) to a Database in AlwaysOn Availability Group

I have a trouble with Adding database file (mdf) to a Database in AlwaysOn Availability Group, detail is bellow: Currently, I have a AlwaysOn Availability Group have a database name DB_1, DB_1 have 2 DataFile is DB_1.mdf and DB_1.ldf. Server hard…
Nguyễn Đình Tĩnh
  • 1
  • 1
0
votes
1 answer

SSRS 2016 Scale-Out on Azure VMs not working

Setup I'm running an AlwaysOn SQL Server Availability Set (from the Azure Always On SQL Server Availability Set Template), and trying to utilize the two SQL Servers in a scale-out NLB setup (I haven't figured out exactly what virtual appliance to…
tphuoc
  • 113
  • 1
  • 10
0
votes
0 answers

DPM (data protection manager) backup with SQL Server 2014 AlwaysOn

I have a SQL Server 2014 AlwaysOn cluster. I created a protection group on DPM, first backup is successfull but when DPM tries to get incremental(tlog for every 15') backup of databases which are member of a availability group, it fails. Other…
ceyhun
  • 1
  • 3
0
votes
1 answer

AlwaysOn - cluster lease timeouts and PREEMPTIVE_HADR_LEASE_MECHANISM

We have recently installed some WSUS updates + SQL 2012 SP3 (yes, all tested without a problem in UAT :) and since than it seems that AO and cluster is having few issues - it seems that cluster's lease is timing out and I am unable to figure out…
TZajaczkowski
  • 11
  • 1
  • 5
0
votes
0 answers

Shrink LOG file in a Always ON

My LDF file is too big (almost 500 GB) because we had some problems. I know that is not good to shrink file, but we need to do it this time. My database is FULL RECOVERY MODE and it is in a Alwayson High Availability. I runned DBCC SHRINKFILE (N'My…
Alexandre_Almeida
  • 131
  • 1
  • 3
  • 10
0
votes
1 answer

Very slow insert performance on large table (EF)

One of our systems has a table that receives around 20k inserts per day - it currently contains ~10m rows. We've just pushed out a system upgrade and I'm getting some shockingly slow performance on inserts to this table now (30-40s traces). Inserts…
James
  • 1,028
  • 9
  • 20
0
votes
1 answer

Azure internal load balancing - Which IP address need to be passed while creating ILB

I have created 2 virtual machines and configured high availability of databases (using SQL Server alwaysOn) Now i want external application to make use of these databases, from the below link it says that I need to create internal…
kudlatiger
  • 3,028
  • 8
  • 48
  • 98
0
votes
1 answer

SSIS Package connect to Readonly Database with Availability Group

I am trying to connect to a secondary server in an availability group to use the readonly version of the database with an OLE DB connection in an SSIS package and can't seem to do it. That simple. Can it be done and if so how? Edited: Forgot to…
SteveB
  • 769
  • 4
  • 18
0
votes
1 answer

Drives Going Offline While Adding Nodes to a Cluster

I have two physical servers Server A and Server B in the same domain and a single subnet. For setting up "Always On High Availability", I created a cluster on Server A. While adding another node i.e., Server B to this cluster, I observed all the…
Yashwanth Aluru
  • 1,125
  • 6
  • 21
  • 28
0
votes
1 answer

SQL Server Always on Clustering, Not able to create listener

I am quite new to SQL Server Clustering with Always on feature so I really sorry if I am asking some silly question. I have setup the windows cluster and was able to set up the always on feature on SQL Server. But when I am trying to create the…
Atul Bansal
  • 151
  • 2
  • 12
1 2 3
…
13 14