Problem restore deleted docs

hi all
i dont know if this is by design can someone correct me

i want to restore deleted doc but gives me error cancelled docs cannot restored so what i did i use replace function in mysql cmd to replace docstatus : 2 to 1 after that i restore it but with a deferent number which is not correct and lead me to run another sql cmd to change name to old one.