Post reply

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

  • April 24, 2009 at 9:46 am

    #983648

    Jeffrey Williams (4/24/2009)

    sharanurampur (4/24/2009)

    Dear Friends,

    I too don't know the exact problem, what I am predicting is we are having 2 instances and I stoped one instance completely(Dissable), and restared service agent 3-4 times, and after i have refreshed DB then it has come. I think it may be conflicting in the 2 instances.

    Thanks

    Sharanu.

    That is why we have asked multiple times for the system configuration (e.g. Memory, number of instances, etc...).

    It's also why we've asked multiple times for errors from the error log so that we can identify the root cause for you.

    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

  • June 30, 2009 at 1:37 am

    #1017403

    run below cmd:

    ALTER DATABASE SET ONLINE

  • April 13, 2010 at 6:00 am

    #1150630

    I believe mine is the memory issue, see below:

    How do you change memory settings if you can't even connect to the server.

    When connecting through SQLcmd I get the same error. Any help will do.

    also when trying to do a repair of the installation same error apprears.

    "

    TITLE: Connect to Server

    ------------------------------

    Cannot connect to ..

    ------------------------------

    ADDITIONAL INFORMATION:

    A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

    "

    What you don't know won't hurt you but what you know will make you plan to know better

  • April 13, 2010 at 8:00 am

    #1150736

    It's annoying and not practical to dig up an old thread, especially one with 4 pages, and then put your own problem at the end. I started to rant more, but deleted that part.

  • March 6, 2014 at 4:29 am

    #1694611

    Here's the solution to ur problem....

    Check this link : http://sqltrends.blogspot.in/2013/03/database-cannot-be-opened-due-to.html

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply