add-sql-server-instances-to-cms
所属分类:SQL Server
开发工具:PowerShell
文件大小:8KB
下载次数:0
上传日期:2017-03-24 13:17:27
上 传 者:
sh-1993
说明: 将SQL Server实例添加到SQL Server中央管理服务器
(Add SQL Server instances to a SQL Server Central Management Server)
文件列表:
AddSQLInstancesToCMS.ps1 (6767, 2017-03-24)
Invoke-Sqlcmd2.ps1 (21740, 2017-03-24)
config.jsontemplate.json (146, 2017-03-24)
# add-sql-server-instances-to-cms
A script for adding instances of Microsoft SQL Server to a [Central Management Server](https://msdn.microsoft.com/en-us/library/bb934126.aspx).
## Usage
Run the script once to generate a configurtion file.
Edit the configuration file `config.json` with the parameters for your environment.
### Configuration Parameters
* **UncategorizedServerGroup** Server group in the CMS for newly added servers.
* **InventoryFilePath** Path to csv files containing instance information. The csv files have to contain tree columns for each instance. 'MachineName', 'DisplayName' _(ex. SQL Server (MSSQLSERVER))_ and 'Status' _(Running/Stopped)_.
* **ErrorLogPath** Path to the error log for the script.
* **CMS** Name of the SQL Server instance acting as CMS.
近期下载者:
相关文件:
收藏者: