Home Forums SQL Server 2005 Backups How to I backup the database without Agent XPs enabled? RE: How to I backup the database without Agent XPs enabled?

  • I would definitely ask WHY the SQL Agent tasks are prohibited. The answer needs to be more than 'the auditor said so', as this just shows the auditor probably knows very little about SQL Server.

    You should be told what exposure exists with SQL Agent, and how that exposure does not exist with the alternatives allowed by the auditor.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara