Restoring Deleted Test Cases

Monday, February 7, 2011

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.

8 Replies
Monday, February 7, 2011
re: inflectra.steve Monday, February 7, 2011
If you don't want to lose the other data entered since that point, then the best solution would be to:

1) Install a test instance of SpiraTest onto another computer (you can use the same license key)
2) Do a restore back into this test instance
3) Now use the Excel Add-In to import all the test cases from this test installation
4) Delete all the test cases / steps from the Excel sheet apart from the ones that you need to restore
5) Remove all the Test Case IDs and Test Step IDs from the Test Case # and Test Step # columns (this will make the Excel Add-In add them to the production server rather than trying to do an update)
6) Now point the Excel Add-In to your production server
7) Now choose the Export option to load the missing test cases / steps into your production instance.
Monday, August 1, 2011
re: inflectra.steve Monday, February 7, 2011

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.



Tuesday, August 2, 2011
re: JohnLBevan Monday, August 1, 2011


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.

Friday, September 16, 2011
re: inflectra.david Tuesday, August 2, 2011

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,


Monday, September 26, 2011
re: JohnLBevan Friday, September 16, 2011
You are very welcome - it has been quite popular!
Monday, December 12, 2011
re: inflectra.david Monday, September 26, 2011
Inflectra Support
You are very welcome - it has been quite popular!
We deleted some test case by mistake and we went on to recycle bin to restore one of the deleted Spira Team folders we found in there. After restoring the folder we can't load Spira-Team at all, we getan error message . Would you please assist us get our setting correct and recover test cases we deleted by mistake.
Your assistance will be highly appreciated.
Wednesday, December 14, 2011
re: ManiBank Monday, December 12, 2011

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.

Thursday, August 23, 2012
re: inflectra.david Tuesday, August 2, 2011
We deleted a number of test cases by mistake but when we went to Undelete them we could not see them there to undelete.
I believe what happened was that a folder was selected and then was delete hit by mistake so everything in the folder got deleted?
Any ideas why these would not have appeared for us to Undelete?
In the end we used the script provided above but that caused other issues so would love to find out about using Undelete in this instance.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Monday, February 7, 2011
  • Last Reply: Monday, May 22, 2017
  • Replies: 8
  • Views: 17742