Post reply

security

  • April 2, 2015 at 7:17 am

    #306447

    what is the difference between reconfigure and reconfigure override

  • April 2, 2015 at 7:21 am

    #1788301

    From https://msdn.microsoft.com/it-it/library/ms176069.aspx

    WITH OVERRIDE

    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. For example, the min server memory configuration option could be configured with a value greater than the value specified in the max server memory configuration option. However, this is considered a fatal error. Therefore, specifying RECONFIGURE WITH OVERRIDE would not disable configuration value checking.

    -- Gianluca Sartori

  • April 2, 2015 at 7:25 am

    #1788303

    In other words, you shouldn't use WITH OVERRIDE unless you're specifying an invalid value or one outside of recommended ranges and know exactly what you're doing.

    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

  • April 2, 2015 at 7:29 am

    #1788307

    deleted

    -- Gianluca Sartori

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply