December 28, 2009 at 2:23 pm
Is there a method (script, utility) to Dump out SQL Server Instance Configuration, Version/SP, etc.
Essentially all the metadata that defines that instance of SQL Server 2005 to be able to compare it against another instance.
My DoubleTake mirroring is failing on target server after we hotfixed the source server, and target tries to come back up again (re-start). I want to compare both instances, one against the other.
Thanks
Zee (Atlanta)
SS DBA
December 28, 2009 at 3:17 pm
pssdiag gives you a bunch, but it has other stuff. Might be able to easily extract the metadata.
December 29, 2009 at 6:11 am
You don't mean sp_configure do you? All the SQL Server settings, memory allocation, all that stuff? Or are you really looking even lower level at the server instance itself? If so, I think I'd go with Steve's suggestion.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 26, 2010 at 11:26 am
Steve,
What and where is this tool/function?
Zee
February 26, 2010 at 11:43 am
It's available as a download from Microsoft. Try here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 2, 2010 at 11:24 am
Thanks Steve.
Zee Atl
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply