Database - MS-SQL 2000
OS - WIN-2003
BaaN c4.

We are getting this error on SQL, and users are not able to login.

"Error: 823, Severity :24, state:3 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 0x000002a970e000 in file 'g:\BaaNData\baandb.mdf'"

Any idea, what the cause of the above error.

Regards,

Is it possible that your backup is still running?

Regards,
Han

No Backup is going on.

Regards.

this article seems to cover that error,
http://support.microsoft.com/default.aspx?scid=kb;en-us;828339

Please check the additional messages in the event viewer just before this event. You might get some clue.

BTW, 823 is a serious error.

Dear All,
Thanks for the information.

To Solve the Problem we did the followings.

1. we have restored the backup.
2. Actual size of database - around 10GB and allcated space size was 80GB, we have shrink it to 40 GB.
3. Actual size of log file was 17GB, we shrink it to 1GB.
4. We have checked the hard-disk for bad sector and corrected the bad-sector (if any). we are not able to find any bad sector.
5. The Drive where the BaaNdb.mdf presents, it was under compress mode, we have de-compressed it ( May be it was the reason)

BaaN is now Working.

Any additional information will help me.

Regards.