Two replicas in AlwaysOn. Backup preference is through secondary (though readable secondary is set to no the backup software backs up from secondary).
The availability databases are backed up through the sql portion of backup software (backs up based on group preference and knows which server to backup from).
The OS is backed up through windows agent of the host and backs up C drive only. SQL is installed in C drive. System databases reside in different drive.
So, around the time when windows agent started to backup the OS side, saw multiple messages in the primary replica (no message in secondary though windows OS job runs about the same time for both).
Messages seen were:
Setting database option Auto_update_statistics to OFF for database "mydb"
Setting database option auto_update_statistics_async to Off for database "mydb"
Setting database option auto_create_statistics to Off for database "mydb"
Setting database option INCREMENTAL to OFF for database "mydb"
Followed by:
Setting database option Auto_update_statistics to ON for database "mydb"
Setting database option auto_update_statistics_async to ON for database "mydb"
Trying to understand why this was triggered. If the windows backup triggered this (uses vss) then why no such message was logged in secondary.
