Restore needs too much space

I'm trying to restore a database from a complete backup (70MB)
and on restore it says that the restore needs 713MB of free space to
continue
Why? and is there a way to get around this?
I assume the transaction log is the suspect...The size of the backup file is usually unrelated to the actual size of the
files that make up the database. It is more aligned with the amount of data
in the files. You really don't have a choice but to find enough disk space
to restore the database to. You can use the
RESTORE HEADERONLY
RESTORE FILELISTONLY
commands to see what is on the backup device.
--
Andrew J. Kelly SQL MVP
"Ben" <test@.test.com> wrote in message
news:OzMXO6IZFHA.220@.TK2MSFTNGP10.phx.gbl...
> I'm trying to restore a database from a complete backup (70MB)
> and on restore it says that the restore needs 713MB of free space to
> continue
> Why? and is there a way to get around this?
> I assume the transaction log is the suspect...
>|||When you restore a backup, the transaction log file is expanded to the
size it had when the backup was made, but it remains empty (the actual
log records are not stored in the backup, only the size of the
transaction log).
Razvan|||And if the data file where, say, 2 GB, but only contained 1.5 GB of data,
you would still need the 2 GB in order for the store to create the original
2 GB data file and then restore the 1.5 GB into.
Sincerely,
Anthony Thomas
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1117432747.852108.163660@.z14g2000cwz.googlegroups.com...
When you restore a backup, the transaction log file is expanded to the
size it had when the backup was made, but it remains empty (the actual
log records are not stored in the backup, only the size of the
transaction log).
Razvan