Multiple Server Management – Finding the Database Server

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.

Read more

SQLShack.com – Multiple Server Mangement – Finding the Database Server

Download the scripts

Import server list into CMS (PowerShell)

Search-CMS (PowerShell)

Query registered servers from CMS (T-SQL)

Leave a Reply

%d bloggers like this: