Database cannot be opened - Error

  • I get error though i have good enough memory and disk space, but every time i restarts sql server service it works fine for some time and then again same error.any idea?

    Database cannot be opened due to inaccessible files or insufficient memory or disk space.

  • you may have to check maximum size settings for the database !!

  • Do you have anti-virus software running? It maybe scanning the data or log file at the time SQL is starting up.

  • Can you have a look at the SQL error log. Please post all of the error messages relating to this 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 4 posts - 1 through 3 (of 3 total)

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