GilaMonster (4/8/2013)

---

mp5387 (4/8/2013)

---

Now for providing transactional backup which method is good? append or overwrite

Neither.

Overwrite would be rather silly with log backups since you need all log backups in sequence to restore. Set it to overwrite and you'll only have the last one, useless for restoring.

Append leaves all backups in the same file which means your file is growing larger and larger and anything goes wrong you lose the entire set of backups rather than one.

All backups to their own file, timestamp in the file name.