[Building Sakai] Recovering a deleted exam and its gradebook entries

[Branden Visser]

Not through the user interface (at least not in 2.5.2).

gb_gradable_object_t has a 'removed' column that seems to be in use. 
This looks like a soft-delete mechanism.

You might locate it by querying something like:

select * from gb_gradable_object_t go
inner join gb_gradebook_t gb on (gb.gradebook_uid='<site id>' and 
go.gradebook_id=gb.id)

Replace "<site id>" with the ID of the instructor's site, and see if the 
Exam entry is there with removed=1.

Thanks,
Branden

Katherine Faella wrote:
> Brandon,
> 
> The exam was created and stored in melete.  We can not get a database 
> restore but I was hoping the gradebook entry is one of those items that 
> are not really removed when they are deleted!  Any chance of that?
> 
> Kathy
> 
> 
> On 12/02/2009 11:09 AM, Branden Visser wrote:
>> Hi Katherine,
>>
>> What tool was the Exam being stored in? If it was the "assignments" 
>> tool, the submissions themselves are not actually deleted, as students 
>> are still able to access them.
>>
>> For grades, is a point-in-time database rollback, or recovering a 
>> nightly snapshot of the database to a staging area for access 
>> considerable options?
>>
>> Thanks,
>> Branden
>>
>> Katherine Faella wrote:
>>> (Please excuse my cross posting.  Tried this on production and got no 
>>> answers.)
>>>
>>> Hi all,
>>>
>>> We are running Sakai 2.5.4.  We have an instructor who has mistakenly 
>>> deleted an exam and therefor has also lost the gradebook column (and 
>>> grades) for the exam.
>>>
>>> Does any one know if I can recover one or both of these, especially 
>>> the grades?  We have our files stored in a filesystem (not in the db).
>>>
>>> Any help appreciated!
>>>
>>> Kathy
>>>
>