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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2010-08-04 : 01:26:32
|
| While I restore my db in one of the dev server, the following error mgs was thrown. How much space is required and how to calculate this into GB. Is the below value represent in bytes or kilobytes. Pls. help me. Thanks."There is insufficient free space on disk volume 'C:\' to create the database. The database requires 1954702950" |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-08-04 : 01:48:31
|
| As far as i know the value is in Bytes. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-04 : 02:34:23
|
I hope its bytes - 1954702950 bytes is 1.8GB ... if it was KB it would be 1,864GB === 1.8TB  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-04 : 02:36:08
|
| Note that the Restore will recreate the database to the original size on the original machine. The database may contain empty space - which can be removed using SHRINK after the restore (or your could SHRINK the source database and then take another backup).The size of the Backup file will be equivalent to the data in the database, not including the empty space in the database (speaking in general terms!) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-08-04 : 17:27:51
|
| You log file in Source Database is huge.Shrink it first and then backup/restore. |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2010-08-05 : 02:03:20
|
| What actually the figure(1954702950) in the error msg mean? Is it bytes/kb ? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-05 : 03:38:22
|
quote:
Originally posted by carumuga
What actually the figure(1954702950) in the error msg mean? Is it bytes/kb ?
I hope its bytes - 1954702950 bytes is 1.8GB ... if it was KB it would be 1,864GB === 1.8TB |
|
|
|
|
|
|
Insufficient space