Snapshot Getting Corrupted

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  March 12, 2015 at 6:51 am

  #315646

  Hi Experts,

  We are facing a weird scenario in which the snapshot is getting corrupted after insert\update few million records in to a table .

  SQL Server 2012

  windows server 2008 R2

  service pack 1

  64-bit OS

  Anyone have any idea which this happens.

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  March 12, 2015 at 7:29 am

  #1783565

  Found below link..

  http://blogs.msdn.com/b/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx

  http://blogs.msdn.com/b/psssql/archive/2009/03/04/sparse-file-errors-1450-or-665-due-to-file-fragmentation-fixes-and-workarounds.aspx