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 Wednesday, April 22, 2009 9:52 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:13 PM
Points: 40,428, Visits: 36,879
GilaMonster (4/21/2009)
sharanurampur (4/21/2009)

when I checked into the log files i got some message like..


No errors there. Are there any messages in the log that relate to the database Common?


Well?
If the DB is suspect, there will be a message somewhere in the log indicating that it is being marked suspect and why.



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 #702481
Posted Wednesday, April 22, 2009 11:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
sharanurampur (4/21/2009)

when I checked into the log files i got some message like..


No errors there. Are there any messages in the log that relate to the database Common?[/quote]

If you cant find it send your log file as an attachment atleast, then we would be able to check through that.

Post #702585
Posted Wednesday, April 22, 2009 10:58 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
Which version and edition of sql server you are using ?


Check whether your .mdf and .ldf files are there ...
Post #702900
Posted Thursday, April 23, 2009 3:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:15 AM
Points: 206, Visits: 330
Hi

Run this command to check if you have any error message related to your common database:

EXEC sp_readerrorlog 0, 1, 'Common' or

EXEC sp_readerrorlog 0, 1, 'suspect'


Post #702977
Posted Thursday, April 23, 2009 5:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:21 AM
Points: 6,743, Visits: 8,517
- How much physical memory (RAM) is installed in the server ?

- Is this a dedicated sqlserver server ?

-
Duration: 14434 seconds. Working set (KB): 10540, committed (KB): 38756, memory utilization: 27%.


My guess... sqlserver hasn't got enough memory available to open your db within timeout times.

You should be able to find that info in the sqlsever ERRORLOG file. (of detect latencies)


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #703039
Posted Friday, April 24, 2009 3:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 3, 2009 8:02 AM
Points: 7, Visits: 17

Dear Friends,
I got the solution for that one, its SQL problem, I don't know whether the solution is correct or not,now my database is working fine,

Thanks spending your valuable time,

Thanks
Sharanu.
Post #703811
Posted Friday, April 24, 2009 3:41 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:13 PM
Points: 40,428, Visits: 36,879
sharanurampur (4/24/2009)

I got the solution for that one, its SQL problem, I don't know whether the solution is correct or not,now my database is working fine,

Mind sharing?



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 #703812
Posted Friday, April 24, 2009 7:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, December 16, 2013 12:24 PM
Points: 476, Visits: 1,376
[b]
I got the solution for that one, its SQL problem, I don't know whether the solution is correct or not,now my database is working fine,



What was the issue? How did you resolve it.



Post #703924
Posted Friday, April 24, 2009 7:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 3, 2009 8:02 AM
Points: 7, Visits: 17

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.
Post #703946
Posted Friday, April 24, 2009 9:20 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:14 PM
Points: 4,363, Visits: 9,545
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...).

My guess is that you did not set the max memory for either instance and because of that you were seeing memory pressure issues. If you set the max memory for each instance, I am betting that you could have both instances up and running with no problems.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #704060
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse