Physical backups consist of raw copies of database directories and files. Logical backups save a database by storing the structures and data in custom logical formats. While physical backups are fast and compact, logical backups are highly portable and can be performed with the SQL server running.