Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Database restoring problem

Author  Topic 

bhavik85
Starting Member

2 Posts

Posted - 2008-12-20 : 04:35:11
Hello I am getting an error:

" System.Data.SqlClient.SqlError: MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file. (Microsoft.SqlServer.Express.Smo)"

while i am having 35 GB free space on my computer and database size needs about 8 gb..... i have other databases also i could restore it without problem....

please give me the solution for the error...

thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-20 : 07:21:46
What's the total size of the data and log files of the database that the backup was made from?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

bhavik85
Starting Member

2 Posts

Posted - 2008-12-22 : 06:27:23
total size of the .BAK file is 1.65GB and my HD is of 40 GB........
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-22 : 08:27:35
I didn't ask the size of the backup file.
How big is the database (file size on disk) that the backup was made from?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -