'Suspect' DB won't open - OS error 32- Help!

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.

(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