SQL DB Restore Error

[LinsLo]

I am getting an error when trying to restore a database. The file names and paths look to be correct. The error states that there is insufficient disk space, but the database being restored is 1.4GB and the amount of space on that drive is 17GB, so this should not be an issue. Does any one have any ideas?

 

[SQLBill]

What size is the backup? Remember, when you backup a database - you are not just backing up the data. You are backing up any indexes, reserved space, unallocated space, etc.

For example, you have a database with 1.4gb of data. But you've had lots of transactions and there's some unallocated/free space of 10gb. When you backup the database you are actually making a 11.4gb backup and that's how much space is needed for the restore.

Look at your databases in Enterprise Manager. Right click on the database, select View and click on Taskpad. Look at the graph of the database size. That will show you ACTUAL size broken into data and unallocated sizes.

-SQLBill

 

[LinsLo]

I see that yes, my sizes were completly wrong. But I still get an error when I try to change the size (in MB) to the size which is needed.

 

[SQLBill]

It's all or nothing. You have to restore the full size of the backup. SQL Server doesn't know what that space was used for, it just knows that 11.4 gb was backed up so it needs 11.4gb to restore.

-SQLBill

 

[LinsLo]

I am restoring to a blank database. For the database I took the backup from, my data size is 1808MB and my log size is 19236MB. So when I create a new database and name the files appropriatly and try to set the initial size of the files to the values specified above, it throws out an error about lack of disk space. Does this make sense?

 

[JayKusch]

SO ... in reading the size of your files (The MDF at 1GB and the LDF/Translog at 19GB) you will need 20GB of free room. In you thread above, you said you only have 17GB of space on the drive. Thus you DO NOT have enough physical drive space to restore.

Thanks

J. Kusch