i have several sql servers doing maintenance plans and backing up the transaction logs to tape. unfortunately it seems that the server keeps adding the transaction logs to the same tape, without overwriting them. Nowadays a transaction log backup to disk takes 2 minutes but when done to tape it is taking up 1hr54minutes. What can i do so that the tape is automatically initialised without having to do it manually... Thanks
SQL Log backup is regarded as differential backup so it will continue to stack up if you don't delete them. One way to do it is to limit the retention period in your maintenance plan. The general rule of thumb is to keep only those log backup file for the interval of complete database backup.