Restore of database failed I wanna restore my database and i use sql server 2012 express edition but when i restore my backup file in sql server management studio, i take this error:


  System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'c:\' to create the database. The database requires 84260749312 additional free bytes, while only 47428677632 bytes are available. (Microsoft.SqlServer.SmoExtended)


My .bak file is 8.27 gb and my C disk has 44.1 gb free space. Why do i take this error ? how can i fix this error ? Thanks in advance.
As Max Vernon states, the database is trying to restore to a location that doesn't have space to contain it.  If the backup file is compressed or mostly empty, you will still need the full uncompressed space to restore to.  Additionally, by default SQL Server will try to restore those files to their original file location, so if that original location does not exist or does not have enough space when you restore, the restore will fail.

In order to see the space and location required for a backup, you can run the following command:

RESTORE FILELISTONLY
FROM DISK='&lt;backup file location&gt;'


The output from this will show all files contained within the backup.  Look at PhysicalName and Size for the restore location and size (in bytes) that SQL Server needs for the restore.  You can change the restore location by specifying the WITH MOVE syntax in your restore statement, but as Max states, there's not much you can do about the space required.