今天在调整一备库的备份策略的时候,执行job失败,其中具体错误信息和解决方法记录下,仅供以后参考使用。
错误信息:
Date 2016/12/21 11:05:48
Log Job History (Job_FULLBACKUP)
Step ID 1
Server WINDOWS
Job Name Job_FULLBACKUP
Step Name mssqlserver_fullbackup
Duration 00:00:00
Sql Severity 16
Sql Message ID 15281
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this se
错误信息:
Date 2016/12/21 11:05:48
Log Job History (Job_FULLBACKUP)
Step ID 1
Server WINDOWS
Job Name Job_FULLBACKUP
Step Name mssqlserver_fullbackup
Duration 00:00:00
Sql Severity 16
Sql Message ID 15281
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this se