Host-based
Microsoft SQL Server backups can be restored as files to a user-specified location. The backups can be attached to an existing SQL Server instance using the SQL Server’s management tools.
It is not possible to apply transaction logs to the restored databases.
Block-based
Microsoft SQL Server backups can be mounted to a Windows client, which provides access to the files. The backups can be attached to an existing SQL Server instance using the SQL Server’s management tools.
It is not possible to apply transaction logs to the restored databases. It is also not possible to revert block-based SQL Server backups.