Hi,
  I would like the know how Truncate and Delete both commands affect the
result  of backup / restore procedure(s) and how I am able to test it.
Tks
Ed

None of the commands will affect the types of backups you can do or the ability to restore from any
type of backup. Be aware that DELETE will log each row deleted, so if you delete a lot of rows, the
next transaction log will be large. TRUNCATE TABLE will only log deallocation of pages, so the
recording of such a statement doesn't use as much space in the transaction log backup.

Show quoteHide quote

Triggers - run for multiple updated
parsing varchar fields
INSTEAD OF INSERT trigger
Why does update run differently standalone vs in procedure?
SELECT different columns based on the value of another column