|
-
Suspect mode being invoked
can anyone tell me what would casuse this error:
2001-09-12 21:21:01.11 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:MSSQL7dataReporting.mdf.
2001-09-12 21:21:01.11 kernel FCB::Open failed: Could not open device C:MSSQL7dataReporting.mdf for virtual device number (VDN) 1.
What other things would cause the Reporting.mdf to be locked so the SQL server could not open it?
-
Suspect mode being invoked (reply)
Jim:
Make sure the reporting.mdf and ldf files are not read only. Right click on these files and property to uncheck the readonly mode. This common in SQL 6.5 but you are using 7.0 however this might solve your problem.
JD
------------
Jim Bello at 9/13/01 5:52:52 PM
can anyone tell me what would casuse this error:
2001-09-12 21:21:01.11 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:MSSQL7dataReporting.mdf.
2001-09-12 21:21:01.11 kernel FCB::Open failed: Could not open device C:MSSQL7dataReporting.mdf for virtual device number (VDN) 1.
What other things would cause the Reporting.mdf to be locked so the SQL server could not open it?
-
Suspect mode being invoked (reply)
This could be anything to be honest, someone copying the file, an NT backup running at the time...
If you run server manager and go to the properties you should be able to see which resources have locks on the file.
Regards,
Karl
------------
Jay Durai at 9/13/01 6:26:40 PM
Jim:
Make sure the reporting.mdf and ldf files are not read only. Right click on these files and property to uncheck the readonly mode. This common in SQL 6.5 but you are using 7.0 however this might solve your problem.
JD
------------
Jim Bello at 9/13/01 5:52:52 PM
can anyone tell me what would casuse this error:
2001-09-12 21:21:01.11 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:MSSQL7dataReporting.mdf.
2001-09-12 21:21:01.11 kernel FCB::Open failed: Could not open device C:MSSQL7dataReporting.mdf for virtual device number (VDN) 1.
What other things would cause the Reporting.mdf to be locked so the SQL server could not open it?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote