Hi,i am looking for a light relational database server with the ability to recover after a crash.I am not looking for sqlite or any other single file db system.

MySQL is very popular. But I don't know what you mean by "light". Its either SQL compliant or it isn't. I also don't know about its ability to recover after a crash. Since its so popular I can only assum that it can do it.

MySQL yes my choice too. Used it for years serious bit of kit, plenty of support on their forums & load of programming examples out there.

If at any time you need to go with a full blown relational database server this one is a serious contender and you wound not be wasting your time learning MySQL.

with the ability to recover after a crash

Depending on what your definition of crash means, yes you can administer MySQL remotely, & it's Free...