Post reply

Snapshot Issue

  • November 30, 2011 at 8:19 am

    #252787

    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

    #1414713

    Did you check Error Log & Event Log?

  • November 30, 2011 at 8:36 am

    #1414721

    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

    #1414728

    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

    http://blogs.msdn.com/b/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx

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

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