• If your database get updated once a day I would backup your database and log before the load, adjust the log to a size that is suitable (preferably avoiding autogrowth) and monitor whilst the data is running in.

    If your transaction log is expanding during the load you can back it up during to manage it OR add more disk space.

    Andrew