Often database administrators must ask themselves a simple, yet tedious question, “what server is that database on,” or maybe, “how many servers do we still have on SQL Server 2005?” This article will cover how to use SQL Server’s Central Management Server to manage your server list and it will demonstrate how to use T-SQL and/or PowerShell to quickly search for the subset of servers that you need in the moment.
SQLShack.com – Multiple Server Mangement – Finding the Database Server
Download the scripts
Import server list into CMS (PowerShell)
Leave a Reply