I have configured Log Shipping where the primary server database has
snapshot_isolation_state_desc reported as
off. I tried to turn it off on the secondary which is a standby read only by using the GUI and by using the T-SQL statement to disable:
ALTER DATABASE ABC SET ALLOW_SNAPSHOT_ISOLATION OFF;
However, it turns back on every time the SQL Server restarts.
Is this expected behaviour? If so, why?