**Restoring a db with size 167049KB**

Hi
I'm working with SQL2000 and I want to restore a db which I've got from
another server into my server with this size : 167049KB,and I've 11gb on
Drive E,but following error appearred after restoring:
"There's insufficient free space on disk volume 'e:' to create the
database.the database requires 28614066176 additional free bytes ,while only
2147155 968 bytes are available. Restore databse is terminated abnormally."
why?Can anybody help me?
Any help would be thankful.Do RESTORE FILELISTONLY and check the sum of size for the database files. Th
is is the size of the
database files when you took the backup and this is the space you need to do
restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M R" <rezvani@.parskhazar.net> wrote in message news:OTxT%23eeVFHA.3424@.TK2MSFTNGP09.phx.gb
l...
> Hi
> I'm working with SQL2000 and I want to restore a db which I've got from
> another server into my server with this size : 167049KB,and I've 11gb on
> Drive E,but following error appearred after restoring:
> "There's insufficient free space on disk volume 'e:' to create the
> database.the database requires 28614066176 additional free bytes ,while on
ly
> 2147155 968 bytes are available. Restore databse is terminated abnormally.
"
> why?Can anybody help me?
> Any help would be thankful.
>|||Looks like the database you backed up might have lot of free space in the
data file (.mdf/ .ndf) or/and Huge Log file(.ldf).Check the original
database size. Just looking the backup size of the database could be
deceiving. The backup file is the size of the data in your database it does
not include the free space.
Try to backup the transaction log in the original database/ if you don't
need the transaction backup truncate the log file and shrink the log file
to a reasonable size. Do not shrink the data file (.mdf / .ndf) that might
create fragmentation on the data.
-regards
Sarav...
"M R" <rezvani@.parskhazar.net> wrote in message
news:OTxT%23eeVFHA.3424@.TK2MSFTNGP09.phx.gbl...
> Hi
> I'm working with SQL2000 and I want to restore a db which I've got from
> another server into my server with this size : 167049KB,and I've 11gb on
> Drive E,but following error appearred after restoring:
> "There's insufficient free space on disk volume 'e:' to create the
> database.the database requires 28614066176 additional free bytes ,while
only
> 2147155 968 bytes are available. Restore databse is terminated
abnormally."
> why?Can anybody help me?
> Any help would be thankful.
>