A good backup tool uses VSS Writers to achieve application consistent backups, which also truncates transaction log files. You can also achieve that without having to do a backup. Here are the few commands:


You can add multiple volumes, if database and log files are located on different disk drives:

add volume D:

add volume E:

begin backup


end backup