Post reply

Error on CheckDB

  • February 12, 2012 at 11:52 am

    #264379

    Hi am getting this error when i run a checkDB on my database.

    Here is the error message i think this is serious ?

    Msg 1823, Level 16, State 2, Line 1

    A database snapshot cannot be created because it failed to start.

    Msg 5123, Level 16, State 1, Line 1

    CREATE FILE encountered operating system error 1450(failed to retrieve text for this error. Reason: 1815) while attempting to open or create the physical file 'E:\SQL_Data\DataMart2.mdf:MSSQL_DBCC14'.

    Msg 7928, Level 16, State 1, Line 1

    The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.

  • February 12, 2012 at 2:13 pm

    #1446067

    Well it's preventing CheckDB from running, so it's a concern in that you can't do integrity checks...

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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