是否默认排除master数据库sp_add_target_group? [英] Is master database excluded by default sp_add_target_group?
问题描述
使用此代码时,默认情况下会排除master数据库吗?
- 将上下文更改为jobdatabase - 添加包含服务器的目标组
EXEC jobs.sp_add_target_group'ServerGroup2'
- 添加服务器目标成员
EXEC jobs.sp_add_target_group_member
@ target_group_name =' ServerGroup2',
@target_type ='SqlServer',
@ refresh_credential_name ='elasticJobMasterCredential', - 刷新服务器中数据库所需的密码
@ server_name ='ugdemo2.database.windows.net '
原因我问这个:
我正在执行一项工作来收集数据库文件大小,并且没有包含有关master数据库的信息。运行以下代码后,我开始收集有关主数据库的信息。
- - 包括服务器目标组中的主目标成员
EXEC [jobs] .sp_add_target_group_member
@target_group_name = N'ServerGroup2',
@membership_type = N'Include',
@target_type = N'SqlDatabase',
@ server_name ='ugdemo2.database.windows.net',
@database_name = N'master'
GO
Hi Taiob,
控制此功能的另一个选项是指定用于进行身份验证的凭据的默认数据库。如果默认数据库是`master`,则可能不需要传递以下语法。否则,您将需要
来指定针对特定T-SQL语句的数据库。@ database_name = N 主跨度>
While using this code does it exclude master database by default?
--Change context to jobdatabase--Add a target group containing server(s) EXEC jobs.sp_add_target_group 'ServerGroup2' -- Add a server target member EXEC jobs.sp_add_target_group_member @target_group_name='ServerGroup2', @target_type = 'SqlServer', @refresh_credential_name='elasticJobMasterCredential', --credential required to refresh the databases in server @server_name='ugdemo2.database.windows.net'
Reason I am asking this:
I was executing a job to collect database file size and information about master database was not being included. Once I ran following code I started collecting information about master database.
--Include master target member from the server target group EXEC [jobs].sp_add_target_group_member @target_group_name = N'ServerGroup2', @membership_type = N'Include', @target_type = N'SqlDatabase', @server_name='ugdemo2.database.windows.net', @database_name =N'master' GO
Hi Taiob,
The other option to control this functionality is to specific the default database for the credential being used to authenticate. If the default database is `master`, then having to pass the following syntax is likely not required. Otherwise you will need to specify which database to target specific T-SQL statements for.
@database_name =N'master'
这篇关于是否默认排除master数据库sp_add_target_group?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!