Restore of database failed .bak file SQL Server 2008 I have faced following error during restoring database:


  TITLE: Microsoft SQL Server Management Studio
  
  Restore failed for Server  (Microsoft.SqlServer.SmoExtended)
  
  ADDITIONAL INFORMATION:
  
  System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 92382625792 additional free bytes, while only 42311290880 bytes are available. (Microsoft.SqlServer.Smo)


Database .bak file size is 697 MB and we have around 39 GB free space on server C drive.

Please anyone let me know, what should I do?
You need to check the actual size of the database files which you can check by running

RESTORE FILELIST ONLY FROM &lt;backup_device&gt;   

This will give you information about the files contained in the backup and their sizes in bytes

You need the same space available on the server as the database file size, the backups can be compressed. 

Now you need to free up more space on c: on the server but I would recommend that you add drives to your server and that you would look at storage best practies