![]() ![]() To configure it, open SSMS 2008 and go into the Registered Servers window. How to Set Up a Central Management Server When the DBA opens SQL Server Management Studio, they point at the CMS, and SSMS grabs the list of registered servers from there. With a CMS, the list of registered servers is stored on the central SQL Server. In a shop with two DBAs, they both have their own desktops (plus maybe laptops) and each machine has its own list of registered servers. Sounds simple – and it is – but it comes in handy, and it’s practically a requirement for a good policy-based management deployment. ![]() At my last company, we had a hard enough time telling everybody when we’d finished adding a new server, or what the new server’s name was, or when we didn’t need to look at a server anymore.Ī SQL Server CMS is just a central repository that holds a list of managed servers. This is useful for fast-changing shops where there’s a lot of servers added and removed. Got more than one DBA? Want to make your life easier? You might want to configure a Central Management Server.
0 Comments
Leave a Reply. |