• A database includes an .mdf file for data, an .ldf file for the transaction log, and potentially more .ndf files for data. There is free space in these files for normal operation and maintenance.

    The backup only includes the data.

    When you perform a restore, the database files are restored to the original size they were when the backup was taken.