Friday, February 10, 2012

backup hang

Hi All,
I have a problem with the backup hang. I make a backup
through EM, completed + verified as well. It doesn't
matter what location I choose. For this example, I used
the default backup SQL location on the same drive.
When I try to restore the backup, it starts, but the
dialogbox did not show progress and it stays there for
ever. In the errorlog I have the error:
udopen: Operating system error 32(The process cannot
access the file because it is being used by another
process.) during the creation/opening of physical device
D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
not open device D:\MRE-DEV-
SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
(VDN) 0.
What I could look at?
Thanks a lot for the help.Seems like you try to restore to a new database name but you don't specify for that database to be
created to use new filename, meaning that SQL Server tries to use the file names that are already in
use by the old database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"MJ" <MJ@.mjsql.com> wrote in message news:06b601c38f4d$f73930c0$a001280a@.phx.gbl...
> Hi All,
> I have a problem with the backup hang. I make a backup
> through EM, completed + verified as well. It doesn't
> matter what location I choose. For this example, I used
> the default backup SQL location on the same drive.
> When I try to restore the backup, it starts, but the
> dialogbox did not show progress and it stays there for
> ever. In the errorlog I have the error:
> udopen: Operating system error 32(The process cannot
> access the file because it is being used by another
> process.) during the creation/opening of physical device
> D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
> 2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
> not open device D:\MRE-DEV-
> SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
> (VDN) 0.
> What I could look at?
> Thanks a lot for the help.

No comments:

Post a Comment