SQL: T-transact to backup database

BACKUP DATABASE <database name>
TO DISK = '<location>'
   WITH FORMAT,
      MEDIANAME = '<media name>',
      NAME = '<name>';

Useful SQL command

Truncat database table:

TRUNCATE TABLE table_name;