Importing settings from one SQL Server 2005 instance to another

  • Atif

    Hall of Fame

    Points: 3578

    Comments posted to this topic are about the item Importing settings from one SQL Server 2005 instance to another

    DBDigger Microsoft Data Platform Consultancy.

  • Marcin Zawadzki

    Mr or Mrs. 500

    Points: 510

    Question is not clear.

    IMHO this tool can be used to import only Sufrace Area Configurator settings, not all instance setting (example: memmory, processor afinity and so on)

    MZ

  • Atif

    Hall of Fame

    Points: 3578

    None of the given options can be used to memory , processor affinity etc. So there should be no confusion to choose the applied option.

    Regards

    DBDigger Microsoft Data Platform Consultancy.

  • Ben Leighton

    SSCommitted

    Points: 1838

    sac doesn't ship with 2008 that I know of... What happens to the command line tool?

  • Ben Leighton

    SSCommitted

    Points: 1838

    Ok so it's configuration manager.

  • SanjayAttray

    SSChampion

    Points: 13157

    SAC transfers Memory configurations also from server A to another server B? I doubt it but I got it right just by fluke. So, no complaining about points.

    I will try next time when I had to transfer server settings to another server.

    SQL DBA.

  • Lempster

    SSCoach

    Points: 15651

    Poorly worded question - ambiguous like some of the questions on the Microsoft exams!

  • TomThomson

    SSC Guru

    Points: 104773

    Marcin Zawadzki (2/12/2009)


    Question is not clear.

    IMHO this tool can be used to import only Sufrace Area Configurator settings, not all instance setting (example: memmory, processor afinity and so on)

    MZ

    It doesn't say "import all settings" or "import the settings", either of which would have had the implication that you seem to be suggesting, but "import settings" which doesn't have that implication (all it requires are that there are at least two settings that can be imported).

    So it's a good clear question without any ambiguities.

    Tom

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

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