Search code examples
sql-serverbackup

Could not restore a database

I do not understand this error message:

There is insufficient free space on disk volume 'S:\' to create the database. The database requires 291.447.111.680 additional free bytes, while only 74.729.152.512 bytes are available.

It is true I have 74GB free on my disk S, but I'm trying to restore a backup file having only 2.4 GB.

Is it possible a backup of 2GB to fill 291 GB?

Later edit: Source database before backup has 52GB (data) + 225G (log).

Solution

  • You can use RESTORE FILELISTONLY FROM DISK = N'C:\Path\YourBackup.bak' to check the space used by the DB in the backup upon restoration. Basically, this will allow you to see how big it'll be, without actually restoring the backup.