• If Logging isnt a priority on the Archive DB then set the recovery model to Simple.

    Also Does IISLog get deleted/renamed every day, as part of the archive process?

    As the Select Into will try and recreate the IISLog table every time, so you might be better off with an INSERT INTO

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices