May 13, 2004 at 6:35 am
Hi,
I've been experiencing this problem 4 night in a row this week. One of our SQL Server 2000 SP3 database "DEMO" falls in Suspect Mode overnight but does not recover by itself . This is what's contained in the errorlog :
As anyone seen this before? Thanks.
2004-05-12 20:11:26.63 spid5 D:\Program Files\Microsoft SQL Server\MSSQL\Data\Demo_log.ldf: Operating system error 1224(The requested operation cannot be performed on a file with a user-mapped section open.) encountered.
2004-05-12 20:11:26.65 spid5 Unexpected error while commiting a ShrinkFile operation
2004-05-12 20:11:26.68 spid5 Error: 9001, Severity: 21, State: 1
2004-05-12 20:11:26.68 spid5 The log for database 'Demo' is not available..
2004-05-12 20:11:27.79 spid14 Starting up database 'Demo'.
2004-05-12 20:11:29.08 spid14 69 transactions rolled forward in database 'Demo' (8).
2004-05-12 20:11:29.08 spid14 D:\Program Files\Microsoft SQL Server\MSSQL\Data\Demo_log.ldf: Operating system error 1224(The requested operation cannot be performed on a file with a user-mapped section open.) encountered.
2004-05-12 20:11:29.10 spid14 MODIFY FILE encountered operating system error 1224(The requested operation cannot be performed on a file with a user-mapped section open.) while attempting to expand the physical file.
2004-05-12 20:11:29.13 spid14 Error: 3414, Severity: 21, State: 1
2004-05-12 20:11:29.13 spid14 Database 'Demo' (database ID 8) could not recover. Contact Technical Support..
2004-05-13 07:43:28.14 spid53 D:\Program Files\Microsoft SQL Server\MSSQL\Data\Demo_log.ldf: Operating system error 1224(The requested operation cannot be performed on a file with a user-mapped section open.) encountered.
May 13, 2004 at 8:24 am
Are you running AntiVirus programs at night? Are they checking the .mdf/.ldf files? If so, that may be causing your problem.
If you are running AntiVirus programs against your database, I suggest checking out the new article for today about AntiVirus programs and SQL Server.
-SQLBill
May 13, 2004 at 9:27 am
Thanks for your reply.
As you were suggesting, the RealTime File scan on our database server is enabled.
As suggested in the article, I'll remove the SQL related file extensions from the scan and hopefully it will solve my problem.
May 13, 2004 at 10:01 am
Great catch. I was suspecting some type of process, backups, anti virus, defrag, etc. holding part of that file open.
Brian Kelley has a great article today on Anti-virus and SQL Server.
May 13, 2004 at 12:51 pm
Yep Steve, that's the article I was referring to. For Jonathan and anyone else who might read this post and need the information - here's the link to the article:
http://www.sqlservercentral.com/columnists/bkelley/
sqlserversecuritydealingwithantivirusprograms.asp
May 14, 2004 at 6:31 am
I have also runn into problems with the server backup tool trying to back up the log and datafiles while the database is active.
Stacey W. A. Gregerson
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply