Thanks Jeffery. The problem here is identifying queries hitting server using bcp or freebcp to copy data without our notice.

CREATE EVENT SESSION [BCP_Queries] ON SERVER ADD EVENT sqlserver.databases_bulk_copy_rows(ACTION(sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_id,sqlserver.database_name,sqlserver.nt_username,sqlserver.sql_text,sqlserver.username)WHERE ([sqlserver].[not_equal_i_sql_unicode_string]([sqlserver].[username],N'''testuser1''') AND [sqlserver].[not_equal_i_sql_unicode_string]([sqlserver].[username],N'''testuser2''')))ADD TARGET package0.event_file(SET filename=N'D:\bulkcopyrows.xel')WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)

 

Thanks Jeffery and Brian for your valuable inputs. My test failed when tried to add 2019 node to 2012 cluster. The original plan is to add Win 2019 new nodes...

• This reply was modified 3 years, 10 months ago by  Dhruva_51.

It's not EBS volumes.  Its NVMe drives attached to instance itself. When we shutdown or stop the instance, all the data on these drives will be lost. I added the...

More info on RHS:

Witness went down restarting all the resources hosting on the same process.

https://techcommunity.microsoft.com/t5/Failover-Clustering/What-is-RHS-and-what-does-it-do/ba-p/371467

 

lifting the thread.

services were running fine. Will look into pushing updates.

Table has cluster index with default setting fill factor. The table has around 15 indexes including clustered. I just went through all indexes and some are set to fill factor...

Move LUNS and attach to the new stand alone instance.

Perry Whittle (2/23/2016)

---

The cluster Client access point is not required for the AG, however for cluster management purposes you will need to ensure you have an IP assignment for each...

This error comes while connecting to sql server not when installing.

I would first install the sp on the secondary node which is not active. Then fail over the cluster to the updated node and wait for few days before applying...

Yes we are setting up Log shipping in our development environment. My concern is whether that the "With standby" will work or not between enterprise and developer edition?

Perry,

I already setup AG and replication and everything is working as expected. I am just trying to find...