navis59 (9/8/2012)

---

Environment: 64 bit version of SQL Server 2008 R2

Issue: When I tried to run a job which pulls about 25GB of data, it kept hanging. I waited for it to roll back. Now the step completed after 8 hrs, but gave this error. I am a developer not a DBA and my DBA also has no clue about this error. Any help would be greatly appreciated. Here's the error:

LogJob History

Step ID11

ServerAE06230

Job Name Append Transactions

Step NameCDR: I03: Append

Duration07:14:24

Sql Severity0

Sql Message ID823

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: dcrecon_admin. ...eration could not be completed due to a file system limitation) to SQL Server during a write at offset 0x00001cc56cc000 in file 'U:\usrdb1\dcfinance\CDR.mdf:MSSQL_DBCC22'. 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. [SQLSTATE 01000] (Message 823) 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 0x0000253035c000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. 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. [SQLSTATE 01000] (Message 823) 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 0x0000253035c000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. 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. [SQLSTATE 01000] (Message 823) 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 0x00002415962000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. 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. [SQLSTATE 01000] (Message 823) 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 0x00002415962000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. 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. [SQLSTATE 01000] (Message 823) 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 0x00001d4429c000 in file 'U:\usrdb1\dcfinance\CENTRAL DATA REPOSITORY.mdf:MSSQL_DBCC22'. 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. [SQLSTATE 01000] (Message 823) 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... The step succeeded.