I have run a script tonight which last for about 4 hours. Near the end of the process, the Messages window indicated this:

"The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases"

Any recommendation on the best way to avoid that?