Posted by Greg D. Moore \(Strider\) on 05/26/05 04:21

<EggsAckley@Last.com> wrote in message
news:mbt9915ei2t78eueqcmudmfdaomv68oujv@4ax.com...
> Hi:
>
> I have a file that I have been told is a SQL Server backup from a
> server somewhere. The file is about 200MB in size
>
> I am trying to create the database on my local server using RESTORE. I
> created the backup device, associated it with a backup name etc.,
> copied the file into the backup dir.
>
> When I run the RESTORE command, Query Analyzer tells me the database
> needs 31 GB of space and the RESTORE aborts. I've tried this several
> times, get the same result every time.
>
> Anybody ever seen anything like this? Is there another way to create a
> DB in a server using a backup file?

Sounds like they may have had a huge database that only contained 200 MB of
data.

Other than havnig 31 GB free, not sure what you can do.

Can you post the results of a RESTORE FILEHEADERSONLY command?


>
> I am running SqlServer 2000, Developer edition on a machine running
> Windows Server 2003 OS.
>
> I would appreciate any help/suggestions.
>
> Waz

[Back to original message]