Post reply

The database is not accessible

  • February 28, 2010 at 6:45 pm

    #219546

    Hi Guys,

    Can you help please.

    We have a database in sql server which we are no longer able to run query on.

    When I click on it, it saying that "The database is not accessible" even when I', logged in using sa login.

    I ran the query "select * from sysdatabases" and I could see that database listed however when I ran sp_helpdb, that database is not listed in the result.

    Can anyone assist please.

    Regards,

    Sun

  • February 28, 2010 at 11:15 pm

    #1126368

    Can you see the database listed in the enterprise manager, if so is there anything written in the braces such as offline or some thing, check with the properties and the file locations of the database , are they in the specified location or not,

    try ur luck

    al da best

  • March 1, 2010 at 12:05 am

    #1126377

    If you query sys.databases, what's the state_desc of the DB that you cannot access?

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

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