So I need to figure out how my vb6 application will store data into the database. I know the options are to store Binary data (BLOB) or use file storage. Here is my situation. I have a client side application that will be accessed from outside the office at several off site locations. The server is located on our home office site where the SQL DB resides. What are my choices for managing the increase in storage needs to house growing uploads of file storage. At about a few hundred pdf, doc, xls files a day, I imagine any space would begin to pile up. What is the best way to keep performance optimal on the database and store data that will be growing? Is there a way to do BLOB and then archive it each year? Perhaps create a second drive on the SQL server and use BLOB or file storage somehow?