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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2010-12-10 : 07:27:27
|
| Hi,When i restore my database from .bak file Then I got this error.There is insufficient free space on disk volume 'C:\' to create the database. The database requires 22681174016 additional free bytes, while only 19623108608 bytes are available.Problems were identified while planning for the RESTORE statement. Previous messages provide details.RESTORE DATABASE is terminating abnormally. is there anyway to restore database without log file or anyway to restore by restricting log file size.i know if i take database backup after shrink it will resolve the case. is there anyway for already taken database backup.thanks. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-10 : 08:28:16
|
| Nope. You need to free up the space that the database needs.--Gail ShawSQL Server MVP |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-11 : 03:08:58
|
| "i know if i take database backup after shrink it will resolve the case. "That's the only option I know of |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-12-13 : 16:55:17
|
| You will need to shrink log file and backup again... |
|
|
|
|
|
|
backup from large log file