The syntax for sp_ldapadmin set_failback_interval is:
sp_ldapadmin 'set_failback_interval', time_in_minutes
Where time_in_minutes is a value from -1 to 1440 minutes (24 hours).
A value of 0 indicates that failing back is manual. That is, the housekeeper task does not attempt to automatically fails back the LDAP server. You must perform this task manually.
A value of -1 sets the fail over time interval to 15 minutes, the default.
If you issue sp_ldapadmin 'set_failback_interval' without any parameters, sp_ldapadmin displays the value to which the fail back interval is set.
If you issue sp_ldapadmin without any parameters, sp_ldapadmin includes the failback time interval in the output:
sp_ldapadmin ---------------- Primary: URL: '' DN Lookup URL: '' Access Account: '' Active: 'FALSE' Status: 'NOT SET StartTLS on Primary LDAP URL: 'TRUE' Secondary: URL: '' DN Lookup URL: '' Access Account: '' Active: 'FALSE' Status: 'NOT SET' StartTLS on Secondary LDAP URL: 'FALSE' Timeout value: '-1'(10000) milliseconds Log interval: '3' minutes Number of retries: '3' Maximum LDAPUA native threads per Engine: '49' Maximum LDAPUA descriptors per Engine: '20' Abandon LDAP user authentication when full: 'false' Failback interval: '-1'(15) minutes (return status = 0)