Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
riya.johnson
Starting Member
17 Posts |
 Posted - 2010-04-06 : 04:24:05
|
| Hi,Iam facing this error while restoring the DB."There is insufficient free space on disk volume 'E:\' to create the database. The database requires 148180434944 additional free bytes, while only 1901887488 bytes are available." [SQLSTATE 42000]As per our analysis, we have found the there is approx only 1 GB difference from last week in size of db size. And the free space in E:\ drive is 1.7 GB. Then why is it giving this error.Riya Johnson |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-06 : 04:37:01
|
| "the free space in E:\ drive is 1.7 GB""The database requires 148,180,434,944 additional free bytes"Looks like the DB needs 148 GB on E:Restore will require enough space to recreate the database to the same size as the original, including any "slack" space in the original, both for DATABASE (MDF / NDF) and LOG (LDF) |
 |
|
|
riya.johnson
Starting Member
17 Posts |
Posted - 2010-04-06 : 05:53:38
|
| I forgot to tell you that there's already this database (147 GB) which has to be overwritten by a fresh backup.Riya Johnson |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-06 : 06:27:05
|
| Could filenames / paths be different to existing?Hopefully SQL would not say it needed 148GB when 147GB already present in the to-be-deleted database? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-04-06 : 12:19:03
|
| if it's overwriting, then can drop the existing db 1st. also, make sure no wasted space in the backup -- for example a db in full recovery with bloated tran log due to not frequent enough tran log backups |
|
|
|
|
|
|
DB restoration error due to lack of space