Post reply

Obtaining MS SQL Server 2005 Configuration

  • July 20, 2009 at 7:09 am

    #133096

    Hi,

    I have a request from my customer to ascertain and capture, in files, the complete configuration of each of the 2000 & 2005 servers that we manage. I have tried 'SAC' and this provides the external information concerning surface area configuration. However, I need all the internal information too. It seems to me, and I could be wrong, that sp_configure does not provide the all the information I need.

    Thanks in advance.....

    Tim

  • August 17, 2009 at 10:52 am

    #1040361

    I have used ' SQL Server Health and History Tool (SQLH2)'for majority of information. Reports sit nicely on reporting services. Cant show you the reports as I have stopped runnign this now... but it was a good little free tool once configured to capture from all server via bat files it did the trick.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en

    Also a little sql script I use is attached too.

    Oraculum

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

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