Hi All,
I've accidentally deleted a workflow. Is there a process to recover the workflow definition?
Tony
Backups of the server?
Maybe from the instance history from when it last run you might be able to get it
If it were me, I would set up a temp SQL and Workflow machine. Restore the Workflow DB to the temp machine. then export the lost Workflow to import into the production Workflow environment.
You want to make sure the subscriber is stopped and all scheduled rules are disabled in this second installation of Workflow. Or just delete the repository registration to prevent it from starting workflows.
If all you want is the workflow definition, not the starting rules, you can get it directly from SQL (after you restored the backup) from the workflow_code table. Find the ID and version you want (the IDs are in the "workflow" table) and copy the contents of the designer_code cell. Paste it into Notepad and save with a .wfx extension.
Is there a better way to do this yet? Can I restore the WF database as is without interfering with the existing installation just to copy from the workflow_code table?
You can restore a copy of the database on the same SQL Server (with a different name).
This worked really well today. I was tentative about restoring to the same SQL server. So I restored to a test server, and it worked like a charm. Saved the day! Thanks Miruna!