One thought I had was to move the files to a file server, then store their respective file paths in the database to link the files to the relevant data in the database. Its a fairly significant ...

Now, in SQL Server 2008, you have the best of both worlds with the introduction of the Filestream storage option. No longer do you have to make compromises.