Support Portal

Welcome, Guest Login

Support Center

DxTransfer Not Able to Copy Microsoft SQL Agent Jobs, Backup Devices, Alerts, or Operators

Last Updated: Jul 17, 2017 03:52PM PDT

Applies to...

  • DxTransfer
  • Microsoft SQL Server

Summary

DxTransfer is not able to copy Microsoft SQL Agent Jobs, Backup Devices, Alerts, or Operators to the target instance when selected in the Options section.

Information

The DxTransfer utility relies on OLE stored procedures that reference SQL-DMO libraries on the source instance to gather data needed to copy agent jobs, backup devices, alerts, and operators. This does not affect the SQL Server target instance. 

The SQL-DMO functionality is not installed by default on Microsoft SQL Server 2008 or later.

To resolve this, you will need to install the "Microsoft SQL Server 2005 Backward Compatibility Components" package.

https://www.microsoft.com/en-us/download/details.aspx?id=24793

Once installed on the source server, jobs, backup devices, alerts and operators can be migrated to the target instance via DxTransfer.

Contact Us

support.desk@dh2i.com
http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete