I wouldn't say it was executed on the secondary - but the updates are sent to the secondary and applied.

Do you want automatic failover - or will you only ever manually failover to the secondary node?  For automatic failover you must have a listener - for manual you can...

Why not use TRY_CONVERT - if it comes back as NULL then it isn't a valid date.  I assume you know that the date format will always be DD/MM/YYYY and...

You need to figure out what that IP address is - then you can start looking for which domain account would be causing the issue.  If the IP address is...

I thought it was someone trying to convert some other dialect to SQL Server.  🙁  I wish people would declare things like that.  Offering help in MySQL isn't a...

Guessing the OP is using MySQL - so this link might be useful: https://www.w3resource.com/mysql/date-and-time-functions/mysql-date_format-function.php

#Fail !!!

You need to keep...

You may not think that database is being used - however, there is an access request trying to access that database.  Let's say application B is using a connection string...

My guess is that the domain controller your system is using hasn't been updated yet - so it has the old credentials, but the SQL Server instance you are trying...

If the log file is full on the secondary - then it is also full on the primary.  If neither log file can grow then your only option will be...

I'm no expert on the subject because we have an "Infrastructure Group" where I work but I wonder if a simple "Clustered Server" would do the trick here.  They...

If you have clients or...

With Standard Edition you are limited to 2 nodes in the cluster - if you need both HA and DR then you would need at least 3 nodes or you...

So what is the strange behavior - and how is that impacting the data transfer?  The process appears to be using SSIS - but knowing just that won't help much.

How...

Just my two cents - if you have an external process (SSIS, Aveva, Informatica, etc.) calling a stored procedure that subsequently calls out of SQL Server to do something that...