db is in supect mode

  • aplcaiton people done some chages .after that changes cpu is more utilised by sql server .so i restarted sql .performance is ok but one my db went suspect .now how can i return back that suspected db

    error is:

    could not open the device D:\programfiels\michrosoft sql server\mssql\data\tiger_data.mdf

    event id:17055

    type :error"

    category:2

  • Is the D drive still accessible?

    Is the .mdf file where SQL expects it to be? (D:\programfiels\michrosoft sql server\mssql\data\tiger_data.mdf)

    Does the SQL Server service account have full rights (read and write) to that file?

    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
  • Gail is correct .......its not able to open the MDF file ..

    Check the SQL Server error logs for the actual error and copy here ..

    It could br due to OS error 3,5 etc ....

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

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

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