What happens to a lawyers case files after they retire and/or die?

Isn’t this one reason why wills are sometimes filed at the court house?

They’re sure he had a will but can’t find it. Wasn’t in his personal effects, files, or even a safe deposit box he had at the bank. This can’t be the first time something like this has happened.