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
2
votes
1 answer

Sql jobs failed randomly to acquire connection after the activation of the Always ON feature

Since we activated the Always On mode on our server, we have some issues regarding our SQL jobs (running SSIS package) which failed randomly with this message : Failed to acquire connection "DB". Connection may not be configured correctly or you…
ElRoro
  • 203
  • 1
  • 13
2
votes
0 answers

SQL Server 2016 secondary often issued error 3456, how to prevent SQL database error 3456?

Could not redo log record (410417:192254:28), for transaction ID (0:1838907632), on page (1:761914), allocation unit 72057594280869888, database '****' (database ID 5). Page: LSN = (410417:191949:3), allocation unit = 72057594280869888, type = 10.…
JoyceLuo
  • 21
  • 2
2
votes
0 answers

SQL Server AG on Kubernetes

I have a Kubernetes cluster and I deploy SQL Server Always On Availability Groups operator on it, but after 2 or 3 days the SQL Server pods get restarting rapidly and they don't work till I delete these pods and they deploying by the Statefulset…
meisam bahrami
  • 107
  • 1
  • 8
2
votes
1 answer

"Enable Always on support..." for SSIS through C# or powershell

I would like turn on Always on support for SSIS. I am able to do this using the UI (Right click on Integration Services Catalogs, click "Enable always on Support"). I would like to see if there is a way to do this in power shell or C# using…
Raman
  • 216
  • 3
  • 15
2
votes
1 answer

SQL AlwaysOn - What if you don't use it as a cluster/failover?

I've been proposed a concept of using two SQL servers using AlwaysOn as a form of replication. With the Primary receiving all data, the secondary being a readonly server for a reports source. Since this feels like the proposal is uncertain as there…
Joseph Morin
  • 45
  • 5
2
votes
1 answer

tSQLt on SQL Server 2017 AG with DTC enabled

I receive the following error when I am running tSQLt tests on SQL Server 2017 that is setup in an Always On availability group that is configured with DTC_SUPPORT = PER_DB on the AG group. If I turn off the DTC Support, it works fine. Our…
silverbullettruck2001
  • 119
  • 1
  • 11
2
votes
0 answers

SSRS report snapshot not releasing transaction and causing tempdb bloat

Scenario: I have a SQL Server 2016 Always On cluster for production data with a readable secondary used as the source of our reporting. I access this data from a different server where our SSRS installation resides. On this SSRS installation I have…
Bryan Maynard
  • 51
  • 3
2
votes
1 answer

Database is read-only error in Secondary Replica of Alwayson Groups

I tried many things and analyzed lots of documents but I haven't found a solution yet. I have three virtual machines in VmWare called (DC,SQLServer01,SQLServer02). All of SQL Servers are member of a domain.(DC) I installed failover cluster for…
omeerkorkmazz
  • 23
  • 1
  • 3
2
votes
3 answers

How to enable Ambient Mode (Always On) in a FragmentActivity on an Android Wear App?

I have an android wear app that contains a FragmentActivity: public class MyFragmentActivity extends FragmentActivity With 2 Fragments: public class MyFirstFragment extends Fragment and public class MySecondFragment extends Fragment I want to…
Moataz Mekki
  • 21
  • 3
2
votes
1 answer

how can I determine if microsoft failover cluster has a quorum (in powershell)

I'm trying to determine if my microsoft failover cluster has a quorum (in powershell). Cmdlet Get-ClusterQuorum gives me quorum configuration - but I need a state. Cmdlet Get-Cluster | fl * gives me a lot of cluster properties, but I cannot find…
Pavel Maltsev
  • 59
  • 1
  • 8
2
votes
1 answer

Microsoft SQL AlwaysOn

Is it possible to determine to which endpoint a client is connecting to. i.e. SQL Availability Group Listener endpoint or the SQL Instance itself. The Problem I'm facing is simple. I've recently started setting up Always On in my environment (80+…
user2889862
  • 128
  • 6
2
votes
2 answers

Can a Sql server AlwaysOn group be a transactional replication subscriber?

If I have a Sql server AlwaysOn Availability Group, can I do a transactional push replication to it?
Mathias Rönnlund
  • 4,078
  • 7
  • 43
  • 96
2
votes
1 answer

SMO Equivalent to SET HADR OFF

In SMO (C#), what is the equivalent to... ALTER DATABASE db SET HADR OFF; I've looked in the documentation for both the Database and AvailabilityDatabase classes and nothing is really jumping out at me. The end goal here is to drop a database that…
Dan Forbes
  • 2,734
  • 3
  • 30
  • 60
2
votes
2 answers

Connection string for entity framework to connect to SQL High Availability servers

I am developing an application using Entity Framework. In this application, the target database is a SQL 2012 High Availability Cluster Servers which has two members. One configured as primary, and the other as secondary. Trying to connect to the…
Syakur Rahman
  • 2,056
  • 32
  • 40
2
votes
5 answers

Connection Timeouts When Using Multisubnetfailover=True

Recently I found that connections were failing from one of our webservers to an MSSQL AlwaysOn Listener. The listener has two IP addresses because it spans subnets so we are specifying Multisubnetfailover=true in our connection string. When…
vesuvious
  • 2,753
  • 4
  • 26
  • 39
1
2
3
…
13 14