Restore of Database Terminates

I have 58 GB of free space on my server and I created a database and tried t
o
restore a 500 mb database and it tells me that it requires 85071298560.
The database i am restoring is quite small and I have space. I dont
understand whats the problem.Please post result fo following. Preferably, the result should be nicely
formatted to make it easy to read.:
restore filelistonly from disk =
'File Name of Database Backup File With Full Path'
"Lontae Jones" wrote:

> I have 58 GB of free space on my server and I created a database and tried
to
> restore a 500 mb database and it tells me that it requires 85071298560.
> The database i am restoring is quite small and I have space. I dont
> understand whats the problem.|||My backup is 534 mb and below is the information from the filelist and it
shows something different
DB1_Data_Data D:\relic\db\Data\db1_Data.MDF D PRIMARY 31055347712 3518437208
0640
Db1_Log D:\relic\db\Data\DB1_Log.LDF L NULL 54018048000 35184372080640
"Absar Ahmad" wrote:
> Please post result fo following. Preferably, the result should be nicely
> formatted to make it easy to read.:
> restore filelistonly from disk =
> 'File Name of Database Backup File With Full Path'
> "Lontae Jones" wrote:
>|||It is obvious from this information that the File Size of the Source Databas
e
is about 28.9 GB for the Data File and 50.3 GB for the Log File. When you tr
y
to restore from its backup, SQL Server will also need to create files of sam
e
size on the destination server. As the Free Space is only 58 GB, the restore
is failing.
Your backup size is so small because the source database has very little dat
a.
So you have following options:
1. Get the source database shrinked, take a backup and restore from that
backup.
or
2. Create about 80 GB Free Space.
Best of Luck.
"Lontae Jones" wrote:

> My backup is 534 mb and below is the information from the filelist and it
> shows something different
> DB1_Data_Data D:\relic\db\Data\db1_Data.MDF D PRIMARY 31055347712 35184372
080640
> Db1_Log D:\relic\db\Data\DB1_Log.LDF L NULL 54018048000 35184372080640|||Yeah I shrank the log and data. Thanks
"Absar Ahmad" wrote:

> It is obvious from this information that the File Size of the Source Datab
ase
> is about 28.9 GB for the Data File and 50.3 GB for the Log File. When you
try
> to restore from its backup, SQL Server will also need to create files of s
ame
> size on the destination server. As the Free Space is only 58 GB, the resto
re
> is failing.
> Your backup size is so small because the source database has very little d
ata.
> So you have following options:
> 1. Get the source database shrinked, take a backup and restore from that
> backup.
> or
> 2. Create about 80 GB Free Space.
> Best of Luck.
> "Lontae Jones" wrote:
>
>