QUESTION POSED ON: 20 February 2004
We are running SQL Server 7 and got the following error message when the
first user tried to log in to a database this morning at 6:13:
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:MSSQL7dataCanada_Data.MDF.
The database option for auto close was set to 'yes,' so the database was
opening and closing every time something ran.
Several processes ran during the night, with the last one at 2:15
showing the database had been opened and closed successfully.
The 6:13 open failed and when looking at the database through Enterprise
Manager the database was listed as 'suspect'.
When looking in the data folder the mdf and ldf files were there and
looked OK. One of the DBAs has the MSSQL 2000 Enterprise Manager and
took the database off line and then put it back on line and it seemed to
fix the issue.
My question is can the auto close option cause a problem like this? We
have since moved that option to 'NO,' but I'm still concerned there may be
something else.
|
