I am kind of in a bit of a Jam.
Seeing a lot of Storage I/O issues.
The OS is MS Windows 2008 R2 (RTM) and MS SQL Server 2008/R2 (RTM).
Based on an analysis I did over the weekend (which is attached), we applied SP1 to both OS and SQL Server this morning.
But, I am still not able to create Database Snapshots. And, when I am able to create them, I
get the following errors:
Date 2/15/2012 11:37:53 PM
Log SQL Server (Current - 2/15/2012 11:39:00 PM)
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 0x0000123b0f0000 in file 'Z:\DATA\JPE_Snapshot.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.