Recover deleted survey?

[BonnieHellevig]

A survey was accidentally deleted. Can it be recovered? How?
Thanks,
Bonnie

[srm_dt]

This happened at our first last year. After some back and forth with Checkbox support, I was given the following SQL script to run - and it worked!
You will need to know the survey GUID. Replace the "xxxxxxxxx" in the last line with that GUID.

UPDATE
ckbx_Template
SET
Deleted = 0
FROM
ckbx_Template t
INNER JOIN ckbx_ResponseTemplate rt ON rt.ResponseTemplateId = t.TemplateId
WHERE
REPLACE(rt.[GUID], '-', '') = ‘xxxxxxxxxxxxxxxxxxxxx’


Stephen Meisner,
Deloitte Canada

[prezzauser]

Hello Stephen,

I have the same issue. Can you please explain two things:

1) What is the GUID and how can I get it for the deleted survey?
2) Where do I enter the above script?

Thanks!

[srm_dt]

The GUID is the unique identifier for the survey. It can be found in any email sent to users to respond to the survey (as long as you are not using Invitations) or in Checkbox itself. It occurs at the end of the URL after "?s=". For example - If the original Activation link for the survey was http://mycheckboxsurvey.aspx?s=123456789 then the GUID is 123456789.

The script is to be run on the SQL server holding your Checkbox data. Ask your IT group to execute the SQL code on the SQL server where Checkbox data resides and to advise you when complete.

It works like a charm. Good luck!

Stephen

Hello Stephen,

I have the same issue. Can you please explain two things:

1) What is the GUID and how can I get it for the deleted survey?
2) Where do I enter the above script?

Thanks!