Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. Error: 3420, Severity: 21, State: 1.
  2. G:Snapshots01DataData1.ss: Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.
  3. Error: 17053, Severity: 16, State: 1.
  4. 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 0x0000a8c4c60000 in file 'G:Snapshots01DataData1.ss'. 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.
  5.  
  6. SELECT DB_NAME(sd.source_database_id) AS [SourceDatabase],sd.name AS [Snapshot],
  7. mf.name AS [Filename],size_on_disk_bytes/1024 AS [size_on_disk (KB)],mf2.size/128 AS [MaximumSize (MB)]
  8. FROM sys.master_files mf
  9. JOIN sys.databases sd ON mf.database_id = sd.database_id
  10. JOIN sys.master_files mf2 ON sd.source_database_id = mf2.database_id AND mf.file_id = mf2.file_id
  11. CROSS APPLY sys.dm_io_virtual_file_stats(sd.database_id, mf.file_id)
  12. WHERE mf.is_sparse = 1AND mf2.is_sparse = 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement