Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Restoring Deleted Test Ca...
In the last week, we have done some rather major reconfiguring of data in projects in test sets and test case moves.
At some point, we lost a major set of test sets GÇô an entire suite.
So, is there a way to restore that test set suite? I have backup of data from before the reconfigurations. I would do a simple restore, however the other work done since the data loss cannot be lost.
FYI: we recently had a similar situation with test cases being deleted. For those, we were able to easily restore them by updating the flag on the database using the SQL below:
Update spiratest.dbo.tst_test_case
Set is_deleted = 0
Where is_deleted = 1
And last_update_date > '2011-08-01 12:00' --or whenever you want to undelete from
Hope that helps some of you.
Cheers,
JB
John
We assumed from the email you had sent that you were on an older version of the system (v3.0 or older) that didn't support un-deletes. With v3.1 (or later) you can just go to Administration > Project History Changes and Restore the items marked as Deleted. This was not possible in previous versions.
That's great - thank you. I think that at the time I spoke to you we were on the old version - we only upgraded fairly recently.
Thanks also for adding that feature - I was just about to write to request it :).
Kind regards,
The Windows recycle bin on the SpiraTest server itself is not related to the Undelete functionality inside the application. It sounds like you may have corrupted some of the SpiraTest program files by doing this. You probably need to backup your SpiraTest database, uninstall SpiraTest and then reinstall, then restore the backed-up database.
And if you have any questions, please email or call us at +1 (202) 558-6885
