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 |
|
thoden.it
Starting Member
4 Posts |
 Posted - 2011-10-04 : 10:52:01
|
I am trying to restore using one of my .bak file and the restore failed.Sql server report this:There is insufficient free space on disk volume 'C:\' to create the database. The database requires 4145872896 additional free bytes, while only 4128075776 bytes are available. But I don't guess from this message is that my .bak file is larger than414587289 bytes because my .bak file to be restored is 190MB in size, I had tried increase space on disk volume C but no betterAny help will be much appreciated.Thanks for reading.=====================In my language - VietnamCác b?n Vi?t Nam có tham gia vào forum này thì giúp mình v?i, mình dang restore file .bak nhung l?i g?p l?i There is insufficient free space on disk volume 'C:\' to create the database. The database requires 4145872896 additional free bytes, while only 4128075776 bytes are available. d?ch th? thì nó báo là thi?u dung lu?ng ? dia, nhung file dó ch? 190Mb và ? dia c?a mình còn t?i 4Gb tr?ng, tru?c dó mình cung dã restore m?t file cùng dung lu?ng v?i file này, khi không còn dùng du?c thì mình dã xóa CSDL dó, Sau dó mình t?o m?t CSDL m?i và restore file nàyCác b?n giúp mình l?i này s?m nhé, dang c?n g?pc?m on dã d?cn?u có th? pm qua yahoo: tommy_1760http://thodencnt.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-04 : 11:27:56
|
| it might be that when trying to create the db from bak the total size of mdf,ldf etc are going beyond max limit. try putting each file onto seperate drive and creating db------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-04 : 12:04:38
|
| "my .bak file to be restored is 190MB in size"When restoring from a backup the original size database will be created - even if the database was empty.So you have to have enough space for the original size of LDF and MDF files.You can include parameters in the RESTORE command to restore the database to a different location - e.g. MDF and LDF files in on different drives, as Visakh has suggested.Once you have restored the database you can SHRINK it to a smaller size, if its size is too large for the new location AND it has some free space. |
|
|
|
thoden.it
Starting Member
4 Posts |
Posted - 2011-10-04 : 12:50:00
|
| Thanks all youOf course, I have moved .bak file to another disk, but it remains the sameanythings else ?http://thodencnt.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-04 : 13:01:08
|
quote:
Originally posted by thoden.it
Thanks all youOf course, I have moved .bak file to another disk, but it remains the sameanythings else ?http://thodencnt.com
No use moving bak fileSuggestion was to give the path for mdf (data) and ldf (log) files while restoring db from.bak file. The paths should point to different drives which has sufficient space------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-12 : 01:57:44
|
| Either you shrink the files on source server and then take backup as suggested above OR you restore the database with MOVE clause to keep files on different drives having ample free space to accomodate the large files. (and then probably shrink) |
|
|
|
|
|
|
|
|
Help me - "There is insufficient free space "