Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Administration  Tools for mapping topology

Author  Topic  adolin Starting Member 1 Post Posted - 2015-03-05 : 21:04:23 Hi Everyone. New to the DBA world here. And i have been given the task of researching what the organisation has and how it is connected as far as MS SQL databases are concerned. I have found out what we have which is multiple servers (varied OS's) running different versions of SQL server. About 60 of them. What i am now struggling with is how they are connected together. Example. We have server1 which is the DB server. I know that it has GUI interface for users which runs on a web server. I also know it has two reports servers which also run on seperate servers. How do i find out or is there a tool or a script or a program which i can use run on server1 which will tell me what is reliant/connected to it? I know there are many varying types of the examble above across my organisation. And no it wasnt documented back at the start or the doco is now so old and out of date it is useless. Thanks guys Aaron