Thanks for your help and advise.

x= alwayson group name.

the query is to return list of Secondary replicas for specific ag , if you run on secondary it should return none for the said AG

i got it, thnx

the result is nothing, thnx

oh and run it on secondary node, thanks in advance

Thanks much

or use vi  editor in liunx.. or notepad ++  https://community.notepad-plus-plus.org/topic/12371/regex-how-would-i-do-this/2

good luck

script tables with data..

and play with this , eventually you will get there.

enterprise edition, sure online index, check here

check VMWare, right size VM , new host added to exi ? check CPU ready

ty , I  fixed em  it by running/executing

select 'EXEC msdb.dbo.sp_syspolicy_delete_policy @name= '''+ name + ''';' from msdb.dbo.syspolicy_policies_internal where is_system=0

union

select 'EXEC msdb.dbo.sp_syspolicy_delete_object_set @object_set_id =' + cast(object_set_id as varchar) from syspolicy_object_sets where...

and for file stream  data storage

end points are fine, I have another group with one database (size about 4 gb) on the same boxes, is working fine.

I have checked the endpoints and port 5022, local...

yes, rebooting the DR node  didn't help.

-- details of last backup (for all databases) performed (full ,diff & log)
USE [Master];
GO

DECLARE @FileSpace TABLE (
[database_id] INT,
[db_name] NVARCHAR(100),
[file_id] INT,
[file_name] NVARCHAR(100),