July 12, 2010 at 7:51 am
I have a problem with my database going suspect, this does not happen everyday, it can three days or once a month.
the error logs produced are shown below
17052 :
Device activation error. The physical file name 'd:\\MSSQL\data\"users database".mdf' may be incorrect.
17204 :
FCB::Open failed: Could not open device d:\\MSSQL\data\"users database".mdf for virtual device number (VDN) 1.
17207 :
udopen: Operating system error 32(error not found) during the creation/opening of physical device d:\\MSSQL\data\"users database".mdf.
where "users database" is my database.
We have other databases backing without a problem, it just seems to happen to this one.
SQL backups are taken every night so we thought this might be the problem, but stopping them didn't help,
they seem to be happening at about 3:00 in the morning.
if anybody has any ideas it would be appreciated
July 12, 2010 at 7:58 am
Operating system error 32 is "The process cannot access the file because it is being used by another process."
Tells me something's trying to read the files while SQL is starting up. Is there an antivirus on that server? If so, are the file exclusions set correctly for SQL?
When you say 'SQL backups are taken', how exactly are they taken? Is anything trying to do file-level backups of the files in the SQL data folder?
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply