|
Home > Archive > Microsoft SQL Server forum > March 2005 > 'Suspect' DB won't open - OS error 32- Help!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
'Suspect' DB won't open - OS error 32- Help!
|
|
| corey_bunch@yahoo.com 2005-03-30, 7:04 pm |
| Help! One of my main databases has been marked as suspect - the
initial problem is that my disk had no space. So I moved some files,
made some space, stopped & restarted the service, and now I get this
error in the errorlogs. There can't be anything else using the
database - I restarted the machine to kill everything that might be
touching it, including the client application.
2005-03-30 14:35:21.96 kernel 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
c:\mssql7\data\<database>.mdf.
2005-03-30 14:35:22.01 kernel FCB::Open failed: Could not open device
c:\mssql7\data\<database>.mdf for virtual device number (VDN) 1.
2005-03-30 14:35:22.03 spid6 Device activation error. The physical
file name 'c:\mssql7\data\<database>.mdf' may be incorrect.
| |
| Erland Sommarskog 2005-03-30, 7:04 pm |
| (corey_bunch@yahoo.com) writes:
> Help! One of my main databases has been marked as suspect - the
> initial problem is that my disk had no space. So I moved some files,
> made some space, stopped & restarted the service, and now I get this
> error in the errorlogs. There can't be anything else using the
> database - I restarted the machine to kill everything that might be
> touching it, including the client application.
>
> 2005-03-30 14:35:21.96 kernel 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
> c:\mssql7\data\<database>.mdf.
>
> 2005-03-30 14:35:22.01 kernel FCB::Open failed: Could not open device
> c:\mssql7\data\<database>.mdf for virtual device number (VDN) 1.
>
> 2005-03-30 14:35:22.03 spid6 Device activation error. The physical
> file name 'c:\mssql7\data\<database>.mdf' may be incorrect.
http://www.karaszi.com/SQLServer/ i...t
_db.asp might give
some ideas.
However, you may find that it's best to restore a clean backup. If you
don't have any clean backup, and that data is dear to you, I would
recommend open a case with Microsoft.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|
|
|
|
|