November 30, 2011 at 8:19 am
I have created snapshot for database but sometime that snapshot went in to suspect mode with below error. I am not able to find any other error in logs.
All the input will be appriciated.
Error:-
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 0x00001839b30000 in file 'F:\MSSQL10.MSSQLSERVER\MSSQL\DATA\database_ss.ss'. Additional messages in the SQL Server error log and system event log may provide more detail.
Thanks!
Jinesh
November 30, 2011 at 8:27 am
Did you check Error Log & Event Log?
November 30, 2011 at 8:36 am
Yes, I did check the event log and error log, both has same error logged which i already mention.
November 30, 2011 at 8:42 am
Jinu43 (11/30/2011)
Yes, I did check the event log and error log, both has same error logged which i already mention.
It's a serious issue. It's time to Call CSS.
BUT Read the following article carefully before taking any action.
SQL Server reports operating system error 1450 or 1452 or 665
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply