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 22, 2009 at 5:36 am

    #982080

    sharanurampur (4/21/2009)

    [font="Verdana"]

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

    Thankis in Advance

    Sharanu.

    Have you verified whether data and log files for database that you are having issue is accessible from drive 'D' as mentioned by Williams.

    Did this happen after restarting sql server? If it is the case, I am sure this command should help you out

    alter database COMMON set offline

    alter database COMMON set online

    Note:- Try this command only if the database did not come up after sql server restart.