0
The application we provide customers with requires an SQL database. Due to the nature of the application, we recommend the recovery mode to be set to Simple as it is not critical data that is stored. One of our customers is using this in a Windows Cluster and have the recovery mode set to Full. When asking them to change this they said that "In a Cluster, the recovery mode for an SQL database must be set to Full". When probing for more info they just said that "that's the way it is". I haven't been able to find any information on Microsoft articles that backs this statement.
Question
Does clustered SQL installations require Full Recovery Mode? If so, why?
EDIT: This is an active-active cluster, but it would be interesting to know both the situation of an active-active and an active-passive cluster.
Ah, thank you, as I suspected :) In order to explain this with backing information, do you perhaps have a link to some Microsoft article confirming this? – MagneTism – 2016-04-08T07:53:05.880
1
I linked already, It does not say full recovery is required. Like it does for mirroring
– gbn – 2016-04-08T07:55:16.930