November 11, 2010 at 1:54 pm
Hi
I am getting lot of the following errors.
The operating system returned error 170(The requested resource is in use.) to SQL Server during a write at offset 0x000020b8322000 in file ‘Drive:\db_name.mdf’. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
All the dbs on the drive are up and running.
Could anyone please help me what to do or what is causing this issue?
Thanks in advance.
SQLRocks
November 11, 2010 at 4:54 pm
sqlrocks79 (11/11/2010)
Additional messages in the SQL Server error log and system event log may provide more detail.
Have you checked these?
It sounds like something's interfering with file access permissions. SAN backup or something similar. Will require some log investigation to determine.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 11, 2010 at 5:30 pm
I would run a checkdb on the database in question as well, as advised.
---------------------------------------------------------------------
November 11, 2010 at 10:05 pm
Also ensure that the Antivirus has been configured exclude .mdf, .ldf, .ndf files
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply