Where do the files go?

If you are are later version on K2, K2 will keep this file temporarily in Isolated Storage (https://msdn.microsoft.com/en-us/library/3ak841sy(v=vs.110).aspx) when interacting with it, but ultimately it will be written to whichever back-end system that the SmartObject interacts with:

If SmartBox/SQL Service Instance; it will usually be Base64 encode in an nvarchar(max) SQL field

If Sharepoint, then it will be stored in Sharepoint Library or List Attachment

Thanks for reply.

It appears the table has grown to large and I need to move the data to a different server. Sadly Package and Deployment tool doesn't seem to work with large data packages.

Is there any method to move the data into a new DB without causing issues. Using a generate scripts method (inside SQL) seems to be unreadable by the smartobject.