Guidance on strategy for serving files remotely using SQL Server
Putting files inside your database tables is almost always a bad idea. Your database server is not a file server.
Store the files on a file server of some sort, and then store the location of the files along with other metadata you might need in the database. Which you're already doing - so keep doing that, you're just going to change where/how you store the files (maybe).
And please, for the love of all you find precious, do not use FTP. It's broken and insecure. Use SFTP, Azure blob storage, or other secure, sustainable, scalable file storage.