I have this problems, that if a schedule inside a Agent job, have not been started for some reason, there will be no errors about this problem. So Í have created this script, that...
The function I use fn_hadr_group_is_primary from this post is a UDF (User Defined Function) that we create in the master database. The function gets an Availability Group name as an input parameter and returns a Boolean value indicating...
This command, can be run on both the primary and secondary node.
Run this command to see if any database on the SQL Server is using enterprise features
IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL
DROP TABLE ##enterprise_features
CREATE TABLE ##enterprise_features
N' USE [?]
IF (SELECT COUNT(*) FROM sys.dm_db_persisted_sku_features) >0
INSERT INTO ##enterprise_features