Yes, it backs up directly from SQL Server, and restores directly to it (it just connects and issues BACKUP and RESTORE commands like you or I would).

Backing up/restoring that much data would be resource intensive, definitely. Depending on your setup, it might hit a network limitation before it hits a storage limitation.

Cheers!