I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happened to my database?

[351 byte] By [DotDotDog] at [2007-12-25]

«« Question about UI layer
»» Is it possible to improve the BoundingSOMETHING design?

# 1

You probably have a Antivirus software scanning the database file and the system is unable to get a lock on the file.

oj at 2007-9-3 >

top of Msdn Tech,SQL Server,SQL Server Database Engine...

# 2

I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting? because my table size is 4.5G .

thx

DotDotDog at 2007-9-3 >

# 3

You can download Filemon from sysinternals.com.

During 'auto growth', the database will be locked but that doesn't sound like the problem you're encountering.

oj at 2007-9-3 >

# 4

The problem still occurred in sql server log. I don't know what happen with that table. it is a 40G database and what can i do with this error?

DotDotDog at 2007-9-3 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33...'

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified