• Eirikur Eiriksson - Friday, January 20, 2017 12:40 AM

     RECONFIGURE WITH OVERRIDE is needed for updating the Running Configuration Value.

    No, it is not.
    https://msdn.microsoft.com/en-us/library/ms176069(v=sql.110).aspx

    Disables the configuration value checking (for values that are not valid or for nonrecommended values) for the recovery interval advanced configuration option.
    Any configuration option can be reconfigured by using the WITH OVERRIDE option. In addition, RECONFIGURE WITH OVERRIDE forces the reconfiguration with the specified value.

    If the setting is one that does not require a restart, the RECONFIGURE will change the setting immediately (ie, change the running value). If the setting is one that requires a restart, it will not. All WITH OVERRIDE does is disable some checks of sensible values.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass