Restore database error

9 Dec 2005 4:48 PM

ninel g via SQLMonster.com

I'm trying to restore a database and am getting the following error:

"MODIFY FILE encountered operating system error 112(There is not enough space
on the disk.) while attempting to expand the physical file. Could not adjust
the space allocation for file 'MyFile_Log'. RESTORE database is terminating
abnormally."

What do I need to do to solve this issue?

Thanks,
Ninel

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200512/1

9 Dec 2005 4:58 PM

Mike Epprecht (SQL MVP)

Hi

You don't have enough disk space for the DB. Full stop.

Don't forget, the size of the backup does not indicate the size of the DB.

Look at RESTORE FILELISTONLY and RESTORE HEADERONLY to get the information
as to how much space you need on disk.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"ninel g via SQLMonster.com" <u9125@uwe> wrote in message

news:5895a870b9427@uwe...
Show quote

> I'm trying to restore a database and am getting the following error:
>
> "MODIFY FILE encountered operating system error 112(There is not enough
> space
> on the disk.) while attempting to expand the physical file. Could not
> adjust
> the space allocation for file 'MyFile_Log'. RESTORE database is
> terminating
> abnormally."
>
> What do I need to do to solve this issue?
>
> Thanks,
> Ninel
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200512/1