June 22, 2010 at 4:51 am
Folks
This is my first post
Q)One of our Production Database is frequently going to suspect(it is happening actually when scheduled nightly backup happening through Mplan
when i checked in the error logs it is showing the following error
Database suspect (xyz) sqlserver error log Message
1)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
2)FCB::Open failed: Could not open device F:ewfolder\data\xyz_Data.MDF for virtual device number (VDN) 1.
3)[298] SQLServer Error: 4060, Cannot open database requested in login
When i restarted the production Server then DB is up & Online
Let me Know the cause of Suspect States. & How to analyze the root cause for this issue.
and i know every time restarting the Production is not recommended but (time Being its restarted.)
At the same time My Temp Db is also growing .
is there any relation between suspect status With tempdb
we are using sqlserver 2000
Your replies will be Appreciated
June 22, 2010 at 5:02 am
jamessdba (6/22/2010)
1)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
Something's locking the file and preventing SQL from opening it. Check that if you have antivirus, the file exclusions are set correctly.
p.s. please post SQL 2000 questions in the SQL 2000 forum in future.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 5:46 am
Thank you Gail for the Quick Response. i will check it.
Sorry for the wrong Place Post.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply