Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Central Management Server (CMS) Rss

Search for any content tagged central management server (cms)

   Items 1 to 7 of 7   
 

Using Extended Properties To Keep Everyone Informed

Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.  Read more...
By E Bond 2014/01/01 (first published: 2010/11/30) | Source: SQLServerCentral.com | Category: central management server (cms)
Rating: |  Discuss |   Briefcase | 8,997 reads

Evaluating Policies on Multiple SQL Server Instances using Central Management Server

you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,174 reads

Manage your environment with CMS

How to setup and use Central Management Server to manage a disperse environment.  Read more...
Rating: |  Discuss |   Briefcase | 4,997 reads

Centralized management: Tips for Managing Backups on Multiple Servers

Managing backups on a handful of servers should be a relatively straightforward process, but what about DBAs that need to automate to stay on top of large numbers of servers? What options are available, and how do they compare? Grant Fritchey looks at what's out there.  Read more...
By 2011/12/16 | Source: SimpleTalk | Category: central management server (cms)
Rating: (not yet rated)  Rate this |   Briefcase | 5,188 reads

SQL Server Central Management Server Security

I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,248 reads

Using Extended Properties To Keep Everyone Informed

Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.  Read more...
By E Bond 2014/01/01 (first published: 2010/11/30) | Source: SQLServerCentral.com | Category: central management server (cms)
Rating: |  Discuss |   Briefcase | 8,997 reads

Policy-based Management and Central Management Servers

Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.  Read more...
Rating:  Rate this |   Briefcase | 1,900 reads
   Items 1 to 7 of 7