| Author |
Topic |
|
jeanh
Starting Member
20 Posts |
 Posted - 2004-08-08 : 12:10:44
|
| I am trying to restore a .bck of a SQL data base to my computer. I am using MSDE. The size of the .bck file is about 200 MB. My computer has 40 GB free. I keep getting an error message that I do not have enough disk space to do the restore. Any ideas? This particular data base seems to restore correctly on some computers (just not the ones that happen to be where I need it to restore). It fails on my Win98 and Win2K boxes but it has also succeeded to restore on Win2K and WinXP. It seems like this is a configuration issue. Thanks for your help.Jean Holland |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-08-09 : 12:57:34
|
| Are you using EM, or running a restore script (Via OSQL)?If you are using a Script, post the script, and the exact error message.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-09 : 13:33:38
|
| So do you have enough disk space on the drives where the MDF and LDF will be created?Tara |
|
|
|
jeanh
Starting Member
20 Posts |
Posted - 2004-08-09 : 23:07:19
|
| I have tried DBAMgr2k and also Microsoft Store Operations Administrator to restore the data base. I will try again and retrieve a copy of the error. I get the same error from both.Jean Holland |
|
|
|
jeanh
Starting Member
20 Posts |
Posted - 2004-08-09 : 23:08:04
|
| Yes, I have plenty of disk space.Jean Holland |
|
|
|
jeanh
Starting Member
20 Posts |
Posted - 2004-08-09 : 23:17:04
|
| Here is the error message:There is insufficient disk space on disk volume c: to create the database. The database requires 9875095552 additional free bytes, while only 2147155968 bytes are available. RESTORE DATABASE is terminating abnormally. I have 64,395,706,368 bytes available on c: according to Windows. The 2.1 GB referenced above looks suspiciously like a signed long int near MAX.Jean Holland |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-08-10 : 00:31:48
|
quote:
Originally posted by jeanh
Here is the error message:There is insufficient disk space on disk volume c: to create the database. The database requires 9875095552 additional free bytes, while only 2147155968 bytes are available. RESTORE DATABASE is terminating abnormally. I have 64,395,706,368 bytes available on c: according to Windows. The 2.1 GB referenced above looks suspiciously like a signed long int near MAX.
do you have a quota set on your disk? I have seen this on winxp systems, not sure if that is configurable on 98/2K though.also, is your OS patched up to date? -ec |
|
|
|
jeanh
Starting Member
20 Posts |
Posted - 2004-08-10 : 19:32:51
|
| I am not aware of a quota setting on Win98. If there is one then I have not altered it from factory setting. I have updated my OS using Windows update whenever a security patch is released.JeanJean Holland |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-08-11 : 02:18:40
|
| Hello Jean!Sounds strangely like you are using old FAT16 which has a file size limit of 2GB. But Win98 should be FAT32, unless you have the option of choosing, I don't remember.Also, I have no real experience with MSDE, but isn't there a hard limit on databases there (like 2GB)? Could that be it?/Andraax |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-08-12 : 15:02:00
|
| Yes,MSDE is limited to DBs less than 2GB-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-12 : 15:20:59
|
| Since the backup file is only 200MB, this database can probably be restored onto MSDE as usually the backup file size is approximately the same size of the used space in the MDF. So the database size is probably only 200MB. The problem though is the size of the MDF and LDF files. You will need to shrink those down at the source. Then backup the database. Then restore onto MSDE.Tara |
|
|
|
|
Data base restore fails