Posted on 2014-09-11
Please analyze. SQL full backup everynight(NOT copy_only) at 7pm. Log file(NOT copy_only) every night at 8pm. Log backup every 4 hours(COPY_only). My network admin wants the copy_only log backup because it will reduce the number of logs backup files to restore in a disaster. The full backup at 7 will create checkpoint and the log backup at 8 is regular. My question is: will the copy_only log backups be of any value. on paper, the copy_only log in the afternoon should contain all transactions since the last log backup(8 pm the night before). Am I missing something?