Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Issues & Questi... > Restoring Deleted Test Ca...

Restoring Deleted Test Cases RSS Feed

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
Mike M.Mike M.
re: Mike M. on Monday, February 7, 2011
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.
John L BevanJohn L Bevan
re: Mike M. on Monday, February 7, 2011
Monday, August 1, 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.



Adam SAdam S
re: John L Bevan on Monday, August 1, 2011
Tuesday, August 2, 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.

John L BevanJohn L Bevan
re: Adam S on Tuesday, August 2, 2011
Friday, September 16, 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,


Adam SAdam S
re: John L Bevan on Friday, September 16, 2011
Monday, September 26, 2011
You are very welcome - it has been quite popular!
mbangu m manikambangu m manika
re: Adam S on Monday, September 26, 2011
Monday, December 12, 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.
Adam SAdam S
re: mbangu m manika on Monday, December 12, 2011
Wednesday, December 14, 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.

Jennifer LalorJennifer Lalor
re: Adam S on Tuesday, August 2, 2011
Thursday, August 23, 2012
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.
  • Started: 2/7/2011
  • Last Reply: 8/23/2012
  • Replies: 8
  • Views: 7038
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.