• I restore the backup to my UAT server and the initial data size explodes to 53gb and the log is set to 1gb.

    Hmm, I think the log file should be the same size as it initially was when it's restored. Are there some other commands running on the db after it is restored? Maybe to reorg/rebuild the data and/or shrink the log?!

    [Btw, 53GB is only ~3.5x 15GB, not 5x :-)).

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.