Agent XPs component is turned off

• batgirl

  SSCarpal Tunnel

  Points: 4979

  More actions

  August 20, 2013 at 9:00 am

  #150449

  I have inherited responsibility for database backup jobs in the absence of a full time DBA. The prior DBA set these up to write the bak files to a network share and we have encountered a lot of problems with this (loss of connection, file in use, time difference, etc.). My immediate requirement is to change these plans to use a local drive for the bak files.

  I have backup device server objects that are currently set to a destination of the network share.

  I am not able to modify maintenance plans or create new ones - I get a message indicating that Agen XPs component is turned off. This happens whether I am using SSMS remotely or on the server itself.

  I have read and understand the recommendation to use:

  sp_configure 'show advanced options', 1;

  GO

  RECONFIGURE;

  GO

  sp_configure 'Agent XPs', 1;

  GO

  RECONFIGURE

  GO

  The sys.configurations view currently shows

  value = 0

  minimum = 0

  maximum = 0

  value_in_use = 1

  is_dynamic = 1

  is_advanced = 1

  I am reluctant to make configuration changes if there is another way to solve this.

  Is dropping and re-adding the backup devices with proper local path the better way to go?