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 5:21 am

    #981322

    TECHBABU (4/21/2009)

    - Check the disk space where the .mdf .ndf or ldf files are located.

    - If the disk space is full due .ldf

    detach the database and add new disk

    move the files there and attach the database

    - This is a offline operation

    I would strongly suggest not detaching the database immediately. Depending on what the root cause is, it may happen that you detach the database and it will not reattach again.

    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