Post reply

operating system error 665

  • July 15, 2016 at 2:25 am

    #315229

    Hi All,

    I am maintaining 2 days snapshots for my database.one snapshot a day.

    i am getting operating system error 665 and my old snapshot is going to suspended state after 1 day.

    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 0x00001e58180000 in file ''G://MSSQL11.PSAPP20//MSSQL//DATA//Datamap_2_20160713.snap''. 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.

  • July 15, 2016 at 4:00 am

    #1890254

    https://blogs.msdn.microsoft.com/psssql/2015/06/10/operating-system-error-665-file-system-limitation-not-just-for-dbcc-anymore/

    https://support.microsoft.com/en-us/kb/2002606

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 15, 2016 at 4:08 am

    #1890258

    Just out of curiosity, how big are these databases, and how much data is changing daily?

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • July 15, 2016 at 7:17 am

    #1890297

    Database size is 300 GB

    Having 2 datafiles each about 120 GB

  • July 15, 2016 at 7:20 am

    #1890299

    The sparse file size is around 60GB when snapshot is going to Suspended state. I have 600 GB free space in disk . and auto growth is 100 MB for database

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply