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

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.