December 12, 2011 at 11:20 pm
I am using Microsoft SQL SERVER 2005 Professional edition.
I am trying to restore database in my d drive. It requires approximately 18 gb space,and i already have upto 18.6 gb of space there. But still i am getting this error time and again- 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.Smo)
December 12, 2011 at 11:38 pm
Please check the size of the restored database using the following command.
RESTORE HEADERONLY FROM DISK = 'DB backup file path'
GO
December 13, 2011 at 2:48 am
akansha.akkii (12/12/2011)
I am using Microsoft SQL SERVER 2005 Professional edition.I am trying to restore database in my d drive. It requires approximately 18 gb space,and i already have upto 18.6 gb of space there. But still i am getting this error time and again- 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.Smo)
1. Ensure that you are restoring the database in D drive.
2. As suggested above cehck BackupSize column from the result of RESTORE HEADERONLY command.
RESTORE HEADERONLY FROM DISK = 'Backup File Path Here'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply