Share via

DBCC failed

Vijay Kumar 2,061 Reputation points
2020-08-24T17:47:37.353+00:00

DBCC CHKDB job failed with the below error: (This is SQL Server 2016 (SP2-CU12) with AlwaysOn)

F:\MSSQLSERVER\MP1\ABCXS_AppData01.ndf_MSSQL_DBCC9: Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.
Error: 17053, Severity: 16, State: 1.

No other errors fround from Errorlog.

Here the the few details:

---SQL JOB--
EXECUTE [dbo].[DatabaseIntegrityCheck]
@Databases = 'USER_DATABASES',
@LogToTable = 'Y',
@PhysicalOnly = 'Y'

  1. DB Size: 2.7 TB
  2. All files are in same drive (SSD).except log file (.LDF)
    Total size of the F:\ drive 4 TB and free space 1.90 TB.
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
2020-08-25T07:37:25.05+00:00

Hi VijayKumar-4406,

File system fragmentation is one possible cause for this. There's lot of info in this article (and some of it applies up to current version of SQL Server): OS errors 1450 and 665 are reported for database data files

From this similar thread.

Best regards,
Cathy

Was this answer helpful?

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. tibor_karaszi@hotmail.com 4,321 Reputation points
    2020-08-31T11:31:55.173+00:00

    You can't estimate the size of the snapshot, since it will start with a size of 0 (well, a few hundred kb) and then grow depending on the modifications that other users are doing while the snapshot is active. "Copy on write."

    If you get the error earlye and without massive modifications going on, then you don't have a size problem with the snapshot. You probably have a file system fragmentation issue or a "close to full disk" issue.

    Was this answer helpful?

    0 comments
  2. Tom Phillips 17,786 Reputation points
    2020-08-24T17:56:36.617+00:00

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.