Hi All,
I previously posted this OS error 665 not CHECKDB.
In summary, I get these errors throughout the day (it's not happened for quite some time, but has started again recently):
"The operating system returned error 665 (failed to retrieve the text for this error. Reason: 15105) to SQL Server during a write at offset 0x00000ad1c8c00 in file 'X:\myfile.ndf:MSSQL_DBCC8'
"Error 17053, Severity: 16, State: 1"
It turns out these errors are caused by Service Broker. I've had a recent spate of them, and every single one is tied to the execution of an activation procedure. We use service broker extensively in our system to replicate messages between instances.
Can anyone confirm what Service Broker's use of sparse files is? I've reviewed the activation procedure and it's relatively simple. There's nothing in there that would account for it, so I presume it's intrinsic to Service Broker.
Thanks in advance, Andrew