problem with db restore

23 Aug 2006 3:48 PM

Kamil Skup

Hi,
I've got file "database" without any extension. This file is a backup of
database. On my computer I have SQL Server 2005 and i don't know what to do
now with it. I tried to open it in SQL but it's no use. Then I have opened
the SQL Management Studio and with right button I clicked on "databases" and
clicked "restore database". In new window, which has opened, "Specify the
source and location of backup sets to restore" i choose "from device" and
then i choose the database. Then I clicked OK, but i've got error:
"Restore failed for Server xxxxxx. Additional information:

System.Data.SqlClient.SqlError: There is insufficient free space on disk
volume xxxxxxxx to create database.... " but this database occupies 1GB, and
on this disk volume I have 10GB free space.
What am I doing wrong? please help

23 Aug 2006 9:22 PM

Jasper Smith

The backup might occupy 1 GB but what were the original file sizes? Run the
command below in a SSMS query and look at the Size column (which is in
bytes) in the results. When the database is restored, the files will be
created with these sizes so make sure you have enough room for them

restore filelistonly from disk = 'your backup file'

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

Show quote

"Kamil Skup" <ks***@wp.pl> wrote in message
news:%23aBYIusxGHA.3464@TK2MSFTNGP03.phx.gbl...
> Hi,
> I've got file "database" without any extension. This file is a backup of
> database. On my computer I have SQL Server 2005 and i don't know what to
> do now with it. I tried to open it in SQL but it's no use. Then I have
> opened the SQL Management Studio and with right button I clicked on
> "databases" and clicked "restore database". In new window, which has
> opened, "Specify the source and location of backup sets to restore" i
> choose "from device" and then i choose the database. Then I clicked OK,
> but i've got error:
> "Restore failed for Server xxxxxx. Additional information:
>
> System.Data.SqlClient.SqlError: There is insufficient free space on disk
> volume xxxxxxxx to create database.... " but this database occupies 1GB,
> and on this disk volume I have 10GB free space.
> What am I doing wrong? please help
>

24 Aug 2006 10:44 AM

Kamil Skup

You were right. Table, which I've got in answer to "restore filelistonly
from disk = 'backup_file' shows, that I need 70GB free space on hdd, I've
got only 40GB free space. Can I do something with this, having only 40GB
free space? Is there some way to handle with this?

----- Original Message -----

From: "Jasper Smith" <jasper_smi***@hotmail.com>

Newsgroups: microsoft.public.sqlserver.tools
Sent: Wednesday, August 23, 2006 11:22 PM
Subject: Re: problem with db restore

Show quote

> The backup might occupy 1 GB but what were the original file sizes? Run
> the command below in a SSMS query and look at the Size column (which is in
> bytes) in the results. When the database is restored, the files will be
> created with these sizes so make sure you have enough room for them
>
> restore filelistonly from disk = 'your backup file'
>
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
>
> "Kamil Skup" <ks***@wp.pl> wrote in message
> news:%23aBYIusxGHA.3464@TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I've got file "database" without any extension. This file is a backup of
>> database. On my computer I have SQL Server 2005 and i don't know what to
>> do now with it. I tried to open it in SQL but it's no use. Then I have
>> opened the SQL Management Studio and with right button I clicked on
>> "databases" and clicked "restore database". In new window, which has
>> opened, "Specify the source and location of backup sets to restore" i
>> choose "from device" and then i choose the database. Then I clicked OK,
>> but i've got error:
>> "Restore failed for Server xxxxxx. Additional information:
>>
>> System.Data.SqlClient.SqlError: There is insufficient free space on disk
>> volume xxxxxxxx to create database.... " but this database occupies 1GB,
>> and on this disk volume I have 10GB free space.
>> What am I doing wrong? please help
>>
>
>

24 Aug 2006 11:09 AM

Steen Persson (DK)

Kamil Skup wrote:

> You were right. Table, which I've got in answer to "restore filelistonly
> from disk = 'backup_file' shows, that I need 70GB free space on hdd, I've
> got only 40GB free space. Can I do something with this, having only 40GB
> free space? Is there some way to handle with this?
>
>

No, the restore will always restore the files to the size they had at
the time of the backup - no matter how much data they actually contained.

--
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator