SQL Server Performance

sp_configure default options

Discussion in 'Performance Tuning for Hardware Configurations' started by vvkp, Mar 26, 2004.

  1. vvkp New Member

    Hi friends,
    Is there anyway to bring back all the configuaration option values to default values?
    Thanks in advance.
    ~vvkp
  2. Twan New Member

    I think that the only ways are:
    - reinstall SQL Server
    - manually set each option to its default value. Most of these are in Books Online under sp_configure, setting configuration options

    Cheers
    Twan
  3. satya Moderator

    I think the second option referred Twan is the other way round, than reinstalling SQL instance again.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page