sestell1 (1/19/2013)
I imagine everyone has their own approach to this.Your approach of using linked servers will definitely work.
I use a C# application I wrote that lets me run T-SQL code against a select list of servers and provides a combined result set.
I also have an Excel spreadsheet with a macro that essentially does the same, but puts results in individual worksheets. I don't manage anywhere near that number of servers though.
Someone else I know uses registered servers somehow to run T-SQL against multiple servers.
As opc.three mentioned, you could probably do this through a Powershell script as well.
I don't know, but I'd guess Redgate offers some sort of tool for this sort of thing.
You can use CMS (central management server) to run scripts against multiple servers at once.
Besides the powershell option there is also ssis which is very good for this.
If you read my blog, you will also find a script to check the backup history.
http://jasonbrimhall.info/2012/11/30/backup-history/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events