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?
Best Answer
You need to check the actual size of the database files which you can check by running
RESTORE FILELIST ONLY FROM <backup_device>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