Recover deleted contract

[erich_grissema]

Dear Community

I deleted a contract by mistake in Spider 6.4.

Is there a possibility to recover it?

Thanks

Erich

[james_ellis · Accepted solution]

Dear Erich,

Recovery is possible but there is more to it:

1. It needs to be done quickly from deletion date.
2. You need to have access to the SQL DB.
3. If procedure is done correctly, it will recover not only the contract but any attached objects to, ie Notes/Documents etc.

The items will be in SQL [Spider_Contract].[sosys].[RecycleBin]

If you look in the table, you find the object that you deleted. Important is the Transaction ID!

Then, you will need open a "New Query" from the Contract DB and run the following (NOTE: Replace # with the ID from the Transaction ID in the RecycleBin table):

EXEC dbo.RecycleTransaction @transactionID= '#'

go

Once complete, you can check the Spider Web for the contract. It should be fully restored. Any questions, Please call support hotline and ask for me or email me direct and I can call you back.

Kind regards,

James Ellis

[erich_grissema]

HI James,

thanks a lot - it worked fine.

Best regards
Erich