June 15, 2011 at 9:21 am
Hi,
I wonder if anyone has any suggestions for finding out all SQL Server instances, and their ip addresses across the network and across different domains?
I have to update an audit started 6 months before I arrived, but there is no documentation on how it was gathered.
I have used SQLCMD and osql but they are only returning a fraction of the servers already known.
Does anyone know if the Microsoft ssessment and Planning Toolkit is to be recommended?
Thanks,
George
June 15, 2011 at 9:24 am
I meant 'Assessment and Planning Toolkit' 🙂
June 15, 2011 at 9:28 am
There are a few tools available for this. SQLPing, Quest Discovery Tool (here http://www.quest.com/discovery-wizard-for-sql-server/ )
And then there is the option to manually investigate the servers.
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
June 15, 2011 at 9:31 am
You might also want to check into PowerShell.
Here is another idea to look into. http://www.sqlservercentral.com/blogs/chadmiller/archive/2011/06/14/t_2D00_sql-tuesday-19-disasters-and-recovery.aspx
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
June 15, 2011 at 9:34 am
Thanks Jason,
I have just looked at the Quest site, and that product looks ideal. I will investigate your other suggestions too.
Kind regards,
George
June 15, 2011 at 9:39 am
You're welcome
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply