July 20, 2009 at 7:07 am
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
July 20, 2009 at 7:12 am
to show server configuration
exec sp_configure 'show advanced options', 1
reconfigure
exec sp_configure
exec sp_configure 'show advanced options', 0
reconfigure
not sure what else they could want but you also send the latest errorlog and\or run the sqldiag utility which will give them OS info as well.
---------------------------------------------------------------------
July 20, 2009 at 7:32 am
George,
Excellent, thank you. Next silly question..... I have 53 servers to execute this against, is there an automated methology? I am a DBA in the UNIX world and have been handed these lovely gems to manage too.
July 20, 2009 at 9:15 am
there is a number of ways of varying complexity, linked server, opendatasource, powershell scripts.
For this I think I would go for a .bat file running a number of osql commands, i.e
osql -Sserver1 -E -i'file with the commands' -o'output file'1
osql -Sserver2 -E -i'file with the commands' -o'output file2'
etc
---------------------------------------------------------------------
July 20, 2009 at 11:25 am
Thank you George! Your assistance is graetly appreciated.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply