Doubts about file storage on server [closed]

It all depends on the solution you want to deploy and what features you already have. Storing in the Database is a good idea, it does not have a big impact on the performance (contrary to what many people think - at least in SQL Server), since in SELECT include as few times as possible the field in which it contains the file. But you have the problem of limiting the Database itself. That is, depending on the SQL Server license you have, this may or may not be a good idea.

If you choose to write outside the Database, you should also think about how you will manage the addresses. For example, "any" user with folder access can perfectly rename the file, put it in another folder, etc., and all this without updating the mapping in the Database.

There is still the Cloud solution, so the story is another.