>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?

Set DB recover mode to Simple before running the script and restore afterwards

ALTER DATABASE Whatever SET RECOVERY SIMPLE