Always estimate the final size of the Stream target table, and make sure that the destination database has enough space to accommodate the Stream job.
If the database that owns the Stream target table, log table, or error table runs out of space, the database returns an error message and the Stream operator terminates the Stream operator job. When this happens, you must allocate more space to the database before you can restart the job.