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

Always On Availability Groups transport has detected a missing log block for availability database

Has anyone else come across this before? How was it resolved in your case? Was it caused by factors outside of SQL Server ie. network transport between replicas (Primary to Secondary) or storage IO? I tried asking the infrastructure team if they…
Hiram
  • 409
  • 1
  • 4
  • 13
0
votes
1 answer

Dynamic SQL, parameterized Query

I've written a query which pulls SQL AlwaysON health information. The only thing left to do is add a where clause in the end to filter the AvailabilityGroupName and DatabaseName. It works when I put in the query: 'select * from results where…
Nicholas Qi
  • 13
  • 2
0
votes
1 answer

How to pivot a result set

I've been tasked to monitor the performance of SQL AlwaysON. I've written a script that would return AlwaysON Availability group information as follow: ; WITH basicaginfo AS( SELECT ag.name AS AvailabilityGroupName, …
Nicholas Qi
  • 13
  • 2
0
votes
1 answer

SQL Server transactional replication to Alwayson group

I have 3 servers. Server A, with a publication database, this server is not part of alwayon group, this server is the distributor Server RT1 and RT2, those servers as part of alwayson group Listener RT, the listener have the subscription to Server…
Salo B
  • 5
  • 3
0
votes
1 answer

How to add a database in the AG Listener SQL server and both created on the primary and secondary SQL Servers?

I have builded up A and B as an AG(Availability Groups) with a listener(such as the DNS name is LSN) and connected to the SQL Server with the account LSN. Now when I creating a database in LSN , the database only created in the A which is Primary AG…
B.Kingsun
  • 350
  • 3
  • 11
0
votes
1 answer

SQL Server always on - Indexes on secondary

We have SQL Server 2016 installed with Always ON enabled. Let's say for simplicity, we have one primary and one secondary. I want users to connect to the secondary only with read only access not the primary. In the primary, I run daily ETL jobs. In…
AbuTaareq
  • 91
  • 2
  • 9
0
votes
1 answer

Powershell Concatenate Variables Result in System.Data.DataRow

I need to get Availability Group and Listener name, concatenate both for a list of servers and then use it to get resource cluster. What I've done so far: foreach ($cluster in GC "D:\TEST\Servers_List_TEST.txt") { $AGName = invoke-sqlcmd…
AdemirP
  • 113
  • 1
  • 3
  • 10
0
votes
1 answer

SSISDB and Always On. How to schedule jobs?

Now that SQL Server 2016 enables SSISDB to be fully High Available, I have a question regarding the job setup. When I do create a SQL Agent Job that executes a SSIS Package that is deployed in SSISDB, should in the job step the Server be the…
Marcos Freccia
  • 35
  • 1
  • 6
0
votes
1 answer

Application intent = readonly SQL Server connection error

I want to connect to an availability group (listener ip) including 4 different database servers. In my connection string, I specify application intent = readonly attribute to connect as read-only. But it fails with a database connection…
John Swayne
  • 13
  • 1
  • 5
0
votes
0 answers

Upgrading a SQL Server 2012 AG to SQL Server 2016 with gMSAs

We currently have a SQL Server 2012 availability group with 2 replicas. We want to move the replicas to new hardware and upgrade to SQL Server 2016. We plan on doing this as a rolling upgrade, as follows: Server A - SQL Server 2012 replica Server B…
user1967479
  • 3
  • 2
0
votes
1 answer

In-Memory Table on SQL 2014 HA cluster not queriable on Secondary nodes

I've set up a simple in-memory table on a high-availability group database on SQL 2014. Querying the table from the primary node directly or from the Listener works fine. If I change the query string to ReadOnly Intent or try to query directly from…
Proxide78
  • 1
  • 3
0
votes
1 answer

Shrink File do not work with Sql Server 2014 with AlwaysOn High Availability group

my problem is really simply: shrink log file does not work. When I execute the maintenance plan (Database full backup and shrink database log) the execution terminate without problems or errors but the log file is used at the same percentage. The…
Michele
  • 23
  • 7
0
votes
0 answers

Routing to a read only replica using a linked server

We have a 3 node AlwaysOn cluster with a primary node, one Read-Only node and a DR node that isn't in the routing list. I set up the read only replica and tested it with MS Access and it works. Problem is we have hundreds of applications and it's a…
Alen
  • 182
  • 7
0
votes
0 answers

My application cannot execute a stored procedure in SQL Server

I have a new AlwaysOn environment where we've moved an old SQL Server 2008 replication databases. I have replication working between the two environments and when I do a manual failover it works wonderfully. The problem that I'm having with this is…
SQL Shell
  • 1
0
votes
2 answers

SQL Server AlwaysON read from multiple seconderies

I configured always-on on one of my environments . SQL1 = Primary SQL2 = Slave1 (readonly) SQL3 = Slave2 (readonly) My Question: I want that my app will read from both slaves servers (for example SQL2 and SQL3 in case that they are the slaves and…
itzik Paz
  • 403
  • 5
  • 14
1 2 3
…
13 14