Hi

if it is filing out

DBCC SQLPERF(LOGSPACE);

check log_reuse_wait column in sys.databases it will show what is the reason

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-databases-transact-sql?view=sql-server-ver15

if this was an incident in the past you could check Reports->Disk usage...

Hi

you need to add column Estimated Recovery Time (seconds) to AG dashboard, it will show how long it will take secondary to catch up with primary.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/use-the-always-on-dashboard-sql-server-management-studio?view=sql-server-ver15

Hi,

1. Log records are sent to other replicas and replicas are responsible for performing modification to data. https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver15 "The primary replica sends transaction log records of each primary database...

Hi, you need db_backupoperator role on db level, so you need to create a user for this login in each db and grant it.

ALTER ROLE db_backupoperator ADD...

Looks like this wasn't automatic but forced failover "because the wsfc cluster was started in force quorum mode". For automatic failover you need proper quorum configuration like as1981 mentioned.

You...

https://docs.dbatools.io/#Update-DbaServiceAccount or if you want write your own piece of code https://devblogs.microsoft.com/scripting/use-powershell-to-change-sql-server-service-accounts/

Looks like classic issue with multi subnet AG Cluster, check this article it explains and provide solutions. In short, stuff from jobs must also use multisubnet option if applicable or...

You must change application connection string to use the driver that support TSL1.2 eg. ODBC 11. Many application use by default "SQL Server" driver that are present on all Windows...

Check the replication, the easiest way will be adding tracer token if it will replicate to subscriber then replication is working, check also log reader agent for any errors.

CDC errors...

More important that if you stop log reader agent then log on publisher database will start to grow as the transaction must wait in log to be distributed to distributor,...

SSRS, SSIS, SAS etc are part of SQL Server, you need SQL Server licenses to run any of this component.

Licensing SQL Server 2017 components, page 15

http://download.microsoft.com/download/7/8/c/78cdf005-97c1-4129-926b-ce4a6fe92cf5/sql_server_2017_licensing_guide.pdf

How is Quorum configured for this cluster? Looks like the primary replica lost quorum and went down, this is intended behavior.

https://docs.microsoft.com/en-us/windows-server/failover-clustering/manage-cluster-quorum

What is the result of

select...

You need to change driver from OLEDB as it don't have support for TLS1.2, there is a new version of OLEDB msoledbsql

https://blogs.msdn.microsoft.com/sqlreleaseservices/released-microsoft-ole-db-driver-for-sql-server/

or use other supported drivers:

https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server

Hi, short answer no. On Windows level there is only Service Master Key which is protected by Windows DPAPI, this key is used by default to protect master key in...

So I don't see a solution, access logic is in wrong place 🙁

You can't limit access on firewall only for app server, and you can't limit access by app name...