Topic: Error 665 by operation with snapshot
Prompt that it is possible to make with snapshot th that it periodically did not fall with an error 665.
The circuit such. There is the main 1 with oltp loading (a various and constant insertion of the data), a DB on another 2, from a mirror in the mornings becomes and already with it users in a mode a-lja olap work, i.e. drive various reports. OS on both servers Win2012R2, SQL2016Enterprise also on both, on disks NTFS, disks - through FC on quite good level (EMC VNX5500), the size of a DB of the order 1.5, a record count in the biggest "problem" table - more 1.
The error looks like:
The operating system returned error 665 (The requested operation could not be completed due to a file system limitation) to A SQL Server during a write at offset 0x0000116fbf4000 in file ' D:\Snapshot\myDB.ss'.
Error: 17053, Severity: 16, State: 1.
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 5:20340841; actual 0:0). It occurred during a read of page (5:20340841) in database ID 7 at offset 0x000026cc0d2000 in file ' D:\Snapshot\myORC.ss'
The error arises at various times, certainly while there are mass changes/inserts to a DB-source. Arose at night earlier, well when the data from remote platforms merged in the general DB, but that is not terrible, in the morning anew formed. Recently even more often in flow of the working day.
That is important. the DB-mirror lies on the same disk, as. On a disk it is enough place, from 3, a minimum 1.2 are always free. A maximum the size to which grew for a day - 300-400.
With what to begin? to transfer on a separate disk? To reduce file size, in which "problem" table (it here this file group myORC in which the error specifies)? There basically, is what to transfer, other tables, indexes...
Mirroring works without problems and errors, by the way.