CODEWITHSUNDEEP
sql-serverbackup
user3104183
user3104183

Reputation: 408

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).

Upvotes: 3

Views: 8902

Answers (2)

Abdus Salam Azad
Abdus Salam Azad

Reputation: 5512

You can restore the database on a separate drive. Let's say you are getting you don't have sufficient space on C: drive, then you can do it on another drive like D:\ , E:\ or anyone. You can do it like the below image

enter image description here

Upvotes: 0

Kahn
Kahn

Reputation: 1660

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.

Upvotes: 1

Related Questions