1.

“You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database.”

Answer»

As the name implies, SQL Server Agent Proxy is an account that grant privilege to the user to execute a PARTICULAR PROCESS or an ACTION when a user does not have rights. The SQL Server Agent Proxies include multiple sub-systems:

  • ActiveX Script – Access to run ActiveX Scripts
  • Operating System (CmdExec) – Access to run Command line scripts
  • Replication Distributor – Replication Agent Rights
  • Replication Merge – Replication Agent Rights
  • Replication Queue Reader – Replication Agent Rights
  • Replication Snapshot – Replication Agent Rights
  • Replication Transaction-Log Reader – Replication Agent Rights
  • Analysis Services Command - SSAS execution rights
  • Analysis Services Query - SSAS execution rights
  • SSIS PACKAGE Execution – SSIS package execution rights
  • Unassigned Proxies – If required option is not able, You can select this like Other option.

All these sub-systems are available under Proxy in SSMS and you can create as per your REQUIREMENT.


Discussion

No Comment Found

Related InterviewSolutions