Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

"Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details." Expand / Collapse
Author
Message
Posted Friday, April 24, 2009 9:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 40,615, Visits: 37,081
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 2008, MVP
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

Post #704090
Posted Tuesday, June 30, 2009 1:37 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 7, 2014 5:50 AM
Points: 52, Visits: 165
run below cmd:

ALTER DATABASE SET ONLINE
Post #744215
Posted Tuesday, April 13, 2010 6:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:43 AM
Points: 1,083, Visits: 597
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
Post #902310
Posted Tuesday, April 13, 2010 8:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:43 PM
Points: 2,838, Visits: 8,570
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.


Post #902424
Posted Thursday, March 6, 2014 4:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 6, 2014 4:28 AM
Points: 1, Visits: 1
Here's the solution to ur problem....

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

Post #1548163
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse