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 3:35 pm

    #981841

    sharanurampur (4/21/2009)

    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,

    Yes, But do you have free space on the disk? What all other files are located on your D drive

    "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.",

    If you assure its not related to disk space then as the error suggest this might be a problem with your Memory on the server? What is the total memory on your server? Can you give us more details on this? and also your SQL server specifications?

    Thanks,