Data loss is not as much a concern because there daily backups of the server and all the data is coming from a source system that has its own backups in place. Thus db (setup by someone else long ago) is "trying" to act as DW.

The long file final reduced to 7G to 1G (which still seems to high) and then has grown back up to 3G.

Don't get why it's so high. There are about 10 active DBS on same server with similar process that do get larger that 300-500mb. With exception of one at 55G (which is also having problems I have to tackle next)