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 Tuesday, April 21, 2009 1:31 PM


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 @ 7:13 AM
Points: 40,627, Visits: 37,092
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?



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 #701807
Posted Tuesday, April 21, 2009 3:35 PM
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)


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,

Post #701923
Posted Wednesday, April 22, 2009 12:34 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
Hello Sir,
ours is SQL server standard edition and we are using only one instance cause it is production server and it is x86.and how to check how much memory is allocated to this instance.

Thanks
Sharanu.
Post #702071
Posted Wednesday, April 22, 2009 12:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 5, 2013 7:41 AM
Points: 1,146, Visits: 230
SQL Server Performance Monitor -> add counter Total Server Memory(in KB)
will display how much memory is allocated by an instance of SQL Server
Memory-Available Bytes
will display how many bytes of memory are currently available for use by processes.
Memory-Pages/sec
will display no of pages in and out to disk. if it is high excessive paging.





Post #702077
Posted Wednesday, April 22, 2009 5:36 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
sharanurampur (4/21/2009)


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



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.



Post #702221
Posted Wednesday, April 22, 2009 5:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
what is the status of your database?

check the status using sp_helpdb
Post #702223
Posted Wednesday, April 22, 2009 5:50 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
Ratheesh.K.Nair (4/22/2009)
what is the status of your database?

check the status using sp_helpdb


I am not sure whether this command works if the database is not accessible.

But other way of checking the status of the database is
select databasepropertyex('','STATUS') this should work.




Post #702242
Posted Wednesday, April 22, 2009 7:03 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
when i check my DB by this query it is showing as Suspect
select databasepropertyex('apdb','STATUS')

and my common DB is not appearing, how to recover that DB

Thanks
Sharanu
Post #702306
Posted Wednesday, April 22, 2009 7:54 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
Check the sql server error log for this database so that you will come to know since when you have this issue i.e this happened when sql server has started or it happened in between.

Once we have this info then we can go from there.



Post #702351
Posted Wednesday, April 22, 2009 9:14 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, December 12, 2014 12:03 PM
Points: 4,363, Visits: 9,547
In Object Explorer - right click on the server name and select properties. Select the Memory page and post back what the min/max memory settings are.

Another question comes to mind - how many databases exist in this instance?


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

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

Add to briefcase ««1234»»»

Permissions Expand / Collapse