Home Forums SQL Server 2005 Administering "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details." RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

  • April 21, 2009 at 10:09 am

    #981591

    Can you access the D drive on the server? Can you navigate to the folder where the mdf/ndf/ldf files exist and verify that they do in fact exist?

    I have seen similar messages when there has been a network outage to the SAN. The outage was only for a second, but SQL Server lost the connection and could no longer access the drive. The only solution for this scenario was to reboot the server. I am not saying this is your problem - so don't just go and reboot the server to try and solve this problem (yet).

    The errors you are getting refer to problems with memory. Are you running SQL Server 2005 Standard? Is it x64 or x86? What is the max memory setting for this instance? Are you running multiple instances on this system?

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs