Hi,

yes readable. There are some selects, but could not see something special what could block synchronization .

Thanks

• This reply was modified 3 months, 1 week ago by  tony28.

Hi,

sorry for the late answer.

Yes this wait was pointed to some problem with memory, so we collected memory clerks, and this time was higher only MEMORYCLERK_SQLQERESERVATIONS

We have full max memory,...

so I guess in SQL2022 it will be

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/contained-availability-groups-overview?view=sql-server-ver16

Hi,

GDR (General Distribution Release) will not include previous all CU's (Cumulative Update) but CU's will include all previous fixes.

So it means its possible to use some security update, when you...

Hi,

I guess in procedure sp_delete_backuphistory is also deleting restore history.

DELETE FROM msdb.dbo.restorehistory

WHERE restore_history_id IN (SELECT restore_history_id

FROM @restore_history_id)

Hi, As Jeff Williams said: "If DR is more important then you can setup a secondary in the other data center, configure a BAG for each database with manual...

fixed with

use [CertDB2]

GO

GRANT AUTHENTICATE TO [CrossDBCertUser]

GO

Hi, thanks for reply.

I tested recreate listener, but there are problems with cluster permissions, and if you will need to do failover back then can be problems.

So i will prefer...

Ok, i tested finally https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver15#monitor-health and see each redo rate per database

I forgot to mention, but I already found it

It wasn't installed by me or our team, but some external consultant and he created some triggers for creating a login on...

If I do with wizard its looks normal working, without a problem, only got an error after click ok or with the script also.

The name is the same like on...

Hi,

like frederico_fonseca mentioned Developer = Enterprise, only cannot be used for production.

About restoring, depends what is your current production, if this is also SQL 2019 is no problem with restore,...

What account is running the SQL Server service?  It seems that this account does not have access to read the local system to retrieve the list of available users.

Are...

Hi,

yes, I did it, and still not possible. it looks the same like I found with the wizard.

I tested

• copy from windows user management to name in the wizard and...

one interesting issue.

If i want to add some login which exists in windows like local account , I got also message The statement has been terminated behind this not found.

If...