Home Forums SQL Server 2005 Administering Log Backups don't keep up during weekend maintenance RE: Log Backups don't keep up during weekend maintenance

  • some suggestions if not already done:

    improve reindex job to only run update stats on indexes where alter rebuild was not run

    do you really need to do full scans?

    put the log backup jobs (as an sp_start job command) into the logic of the reindex job to give more control over when they run

    remember update stats does not produce much log activity.

    ---------------------------------------------------------------------