Showing posts with label disk. Show all posts
Showing posts with label disk. Show all posts

Monday, March 19, 2012

Error in Restore Database

Dear all,
I get the following error when restore database :
Modify File encountered operating system error 112(There is not enough space
on the disk) while attempting to expand the physical file.
Can anyone tell me how I can overcome this problem ?
Thx.The error is very spcific - you don't have enough space on the disk.
You can delete some files in order to make more space on the disk or
restore the database to a different disk.
Adi
Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.|||Hello,
The Restore Database command will create a identical MDF and LDF which is
same as source database. So ensure that
you have enough space in physical hard drives you are going to restore.
Otherwise identify the right drives with space and
restore in that location.
Thanks
Hari
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23XphYUhPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough
> space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>|||Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
Which part of "There is not enough space on the disk) while attempting
to expand the physical file" is unclear?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Error in Restore Database

Dear all,
I get the following error when restore database :
Modify File encountered operating system error 112(There is not enough space
on the disk) while attempting to expand the physical file.
Can anyone tell me how I can overcome this problem ?
Thx.
The error is very spcific - you don't have enough space on the disk.
You can delete some files in order to make more space on the disk or
restore the database to a different disk.
Adi
Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
|||Hello,
The Restore Database command will create a identical MDF and LDF which is
same as source database. So ensure that
you have enough space in physical hard drives you are going to restore.
Otherwise identify the right drives with space and
restore in that location.
Thanks
Hari
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23XphYUhPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough
> space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
|||Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
Which part of "There is not enough space on the disk) while attempting
to expand the physical file" is unclear?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Error in Restore Database

Dear all,
I get the following error when restore database :
Modify File encountered operating system error 112(There is not enough space
on the disk) while attempting to expand the physical file.
Can anyone tell me how I can overcome this problem ?
Thx.The error is very spcific - you don't have enough space on the disk.
You can delete some files in order to make more space on the disk or
restore the database to a different disk.
Adi
Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough spa
ce
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.|||Hello,
The Restore Database command will create a identical MDF and LDF which is
same as source database. So ensure that
you have enough space in physical hard drives you are going to restore.
Otherwise identify the right drives with space and
restore in that location.
Thanks
Hari
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23XphYUhPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough
> space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>|||Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough spa
ce
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
Which part of "There is not enough space on the disk) while attempting
to expand the physical file" is unclear?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Friday, February 24, 2012

Error in backup process.

Hi everybody,

I'm trying to backup a database of 330 GB more or less from my server to an external hard disk connected by optical fiber and I'm receiving the next error:

[SQLSTATE 01000] (Message 3211) Write on "H:\sqlbackup\pm_import" failed: 33(The process cannot access the file because another process has locked a portion of the file.) [SQLSTATE 42000] (Error 3202) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Any idea?

Thanks!

refer this link,

http://msdn2.microsoft.com/en-us/library/ms837537.aspx is there any other process that is accessing your db just type sp_who2 and see if anything is accessing your db.......any operations going in your db other than backup any bulk insert etc?......

|||Absolutely nothing! I put the batabase in SINGLE_USER mode.

|||

no need to bring to Single user mode . SQL Server has online backup architecture. The problem seems to be the Target file. ie the Backup file in H:\SQLBackup. check any process is using the file when u take backup. It need exclusive access to that file. to debug the issue... create a new database and take backup in the same path ie . H:\sqlbackup\test.bak or something like this. if u r getting same error then the problem may be something else. post back the result of this debug process i mentioned

Madhu

|||

Thank you very much Madhu. I thought the data file was locked by another process, but in fact it was the target file who was block by the anti-virus.

So problem solved!

Thanks again.