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."

  • Dear Friends,

    Thanks for your valuable response,

    here i am giving some more details,

    my database is located at D drive and it is having 22GB space,

    and mainly effected DB is common, its .mdf is 100MB and .ldf is 450MB, and

    when i open the SQL server management studio and I suppose to query as

    "Use common" then I am getting this problem "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.", and my applications user name and password are stored in this DB so i am not able to access the application. and beside in Object explore I am not getting +sign to explode that database, its something locked.

    please give me the solution so that my application works properly.

    Thanks

    Sharanu.