SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


"Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space....


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

Author
Message
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87431 Visits: 45272
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, 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


maechismo_8514
maechismo_8514
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1840 Visits: 2228
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,
sharanurampur
sharanurampur
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 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.
manoj2001
manoj2001
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1193 Visits: 240
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.



murthykalyani
murthykalyani
SSChasing Mays
SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)

Group: General Forum Members
Points: 644 Visits: 1382
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.



VastSQL
VastSQL
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4415 Visits: 5157
what is the status of your database?

check the status using sp_helpdb
murthykalyani
murthykalyani
SSChasing Mays
SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)

Group: General Forum Members
Points: 644 Visits: 1382
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.



sharanurampur
sharanurampur
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 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
murthykalyani
murthykalyani
SSChasing Mays
SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)

Group: General Forum Members
Points: 644 Visits: 1382
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.



Jeffrey Williams 3188
Jeffrey Williams 3188
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7707 Visits: 9971
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 opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search