time-clock-circle multiple-users-1 bin-paper-1 smiley-indifferent view-off alert-diamond envelope-letter rating-star network-browser pencil-write ticket-1 button-record headphones-customer-support close synchronize-arrows-1 common-file-stack close-quote arrow-down-2 multiple-circle attachment-1 folder-file-1 disable smiley-indifferent shield-warning love-it smiley-smile-1_1 check-circle-1 time-clock-midnight floppy-disk view smiley-unhappy book-star lock-unlock-1 arrow-right-1 archive smiley-unhappy send-email-1 hierarchy-9 open-quote add-circle-bold search remove-circle cog-1 filter-1 hyperlink-2 analytics-pie-2 flying-insect-honey navigation-menu-horizontal pencil-1 smiley-thrilled check-1 arrow-up-1 lock-2 navigation-menu add layout-module-1 archive arrow-left-1 wench arrow-down-1 multiple-neutral-1 expand-6 close drawer-send alarm-bell-1 social-media-twitter keyboard-arrow-up ticket-1 copy-paste rating-star download-thick-bottom information-circle smiley-sad-1 single-neutral-actions remove-square-1 file-code pencil-1 keyboard-arrow-down smiley-sad-1 cog single-neutral add-circle move-to-top list-bullets expand-6 undo tags-double smiley-happy view-1 messages-bubble-square print-text add-square smiley-happy credit-card-1 envelope-letter diagram-fall-down

SQL Cluster Plan Returns 0xfffffffff

1. In a SQL cluster environment, the SQLPrep.exe binary does not run automatically. SQLPrep.exe checks for SQL 2008 Management Objects, SQL CLR Types, and XML Core 6.0. If not installed, these applications are installed on the SQL server. Run SQLPrep.exe.

  • Copy SQLPrep.exe to the local drive of the SQL Server.
  • Open a command prompt with admin privileges
  • Change to the directory that contains SQLPrep.exe
  • Type SQLPrep.exe ACCESSDIR=\\[EPS Server Name]\AIQRemote$

2. Manually create the scheduled task for the SQL protection plan. If the task returns 0xffffffff in the Last Result column, remove and re-enter the additional arguments in the Add Arguments field of the Action tab of the Scheduled Task. Make sure there are no extra blank spaces. Save and run the plan again.

3. Check to see whether SQLPlanLaunch.exe is opened multiple times by remote computers in the network running SQL plans. Wait until those open handles close to run the plan again.