Post reply

Database in suspect mode

  • February 1, 2009 at 2:09 am

    #200757

    Hi, I got a SQL Enterprise manger, while taking arch backup on tape the backup failed and data files gone to SUSPECT mode. Can someone guide me to come out of the suspect mode.

    following error message pops up when i try to run my application

    "Could not establish connection

    Description: Cannot open database requested

    Native error 4060

    Source microsoft OLE DB Provider for SQL server

    Sql State :42000"

    Thanks & Regards,

    Fahim

  • February 1, 2009 at 5:17 am

    #936139

    Check the SQL error log. There should be an entry that states why SQL is marking the databases suspet. If you'renot sure, post that and any other error messages relating to that database.

    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