Your search for "always on" returned 100 results:
Hello there! I'm having an issue with Always On, I'm all set up with two replicas in the AG. When testing failovers with our Cognos setup, the app is no longer able to connect to the DB until I drop the user and recreate it using the proper user mapping (it defaults to public only). […]
2023-10-18
926 reads
SQL Server 2016 standard edition, with primary databases and one other server set up as secondary failover with always on availability group. There were some issues over the weekend with an application that accesses the databases on this server, unbeknownst to me, they decided just to reboot the database server, which seemed to clear things […]
2019-12-09
4,848 reads
Question for the group. We just setup a new SQL 2014 SP1 system with two servers and have all of the databases setup in AlwaysOn. My question is when it comes time to apply a service pack or a CU do you have to take all of the databases out of the AG, apply the […]
2016-02-04
2,572 reads
Hello everyone! I would glad to know, what is the difference in Always on between Standard and Enterprise edition? And also there is something that change in 2012 and above? Thanks!
2019-12-09
8,472 reads
Hi all, We have SQL 2017 on windows physical host. This is with Always on set up with 20 databases. We are facing high cpu usage. Previously the usage is below 85% and suddenly started 90% and above. It’s fluctuating be 80-99%. We did the statics update on all databases. We have index defragmentation job […]
2023-03-02
974 reads
Hi All, Over the past week, I've been monitoring my AOAG setup and I've noticed around the same time each night, my primary fails over to my secondary instance. This happens to be right after the VM backup tool runs that I get notifications about errors 1480 and 19406. Good to know those are working […]
2018-08-05
2,520 reads
Hi All, I am planing to change the sql server service account in two node always-on setup. Need to know the steps that needs to be taken which is a recommended way. Also, what are the minimum permission required to give this new service account on the domain. I know we need to give certain […]
2018-01-29
3,048 reads
2018-10-25
741 reads
Hello, I am writing a tsql statement but every time i run it, it comes up with error: The target database ('Database_Name') is in an availability group and is currently accessible for connections when the application intent is set to read only. So i am trying to find a way to exclude Always On Read-Only […]
2021-01-11
253 reads
Another DBA mistakenly created a file share witness for one of our ao clusters. To make matters worse, it's pointed at a server we decommissioned. The cluster doesn't seem to be negatively impacted by it, but it is throwing a set of critical errors dozens of times a day and I hate that. Our cluster […]
2024-02-21
3,060 reads
By Chris Yates
In the intricate world of business, where precision and efficiency are paramount, managing database...
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Comments posted to this topic are about the item Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers