Hi all ,
recently my DBCC checkdb job is failing in production ,after spending some time in google search did not find the answer i was looking for .DBCC chekcdb job failing with error below
DBCC CHECKDB (MyDB) WITH all_errormsgs executed by -sqlsvc found 0 errors and repaired 0 errors. Elapsed time: 6 hours 48 minutes 0 seconds. Internal database snapshot has split point LSN = 00fcd2af:00006980:0012 and first LSN = 00fcd2af:00006911:0001.
S:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\myDB_F2.ndf:MSSQL_DBCC7: Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.
Error: 17053, Severity: 16, State: 1.
The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00005d4c76a000 in file 'S:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\myDB_F2.ndf:MSSQL_DBCC7'. 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.
what i did :
1. i make sure there is no jobs are running in same time DBCC checkdb run
2.my database is 600GB and i know DBCC checkdb create internal snapshot so i make sure i have lots of space ,space is not an issue .i have 2TB free space .
please help .
thanks
