Post reply

Database suspect mode

  • February 9, 2011 at 12:50 pm

    #231153

    I am getting error sql server 2000 enterprise editon.. production database..

    I could not do any action . because database not in entry master db..

    Please help me..

    This is error"

    I/o error 2 (The system cannot find the file specified) detected during write at offset 0x0000007cf8a000 in file E:\Program Files\MSSQl\prod.mdf'

  • February 9, 2011 at 1:15 pm

    #1284797

    Is the file actually present on the E drive. Sometimes I get this when a SAN volume goes offline.

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • February 9, 2011 at 1:19 pm

    #1284800

    Yes. Raid level problem bad stripe.. but i have 2 days before backup was there.. how to up database to normal status... backup also not worked .. any luck

  • February 9, 2011 at 1:35 pm

    #1284807

    Fix whatever is still wrong with E drive then restore your last good backup.

    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 4 posts - 1 through 3 (of 3 total)

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