Soft Delete VS hard Delete

Guys what are you thoughts on soft delete for db entries, this is typically where you have an extra field that has a flag of inactive / active.

So db entries don't actually get deleted but just tagged as inactive, and any query search, searches for all fields that are set as active.

This allow extra safety in case the end user accidentally deletes something they didn't wish to.

Is this extra work in the programming back end worth the hassle?

Thoughts please?

Soft delete > hard delete. accidentally deletes can be faster restored. Time = money