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
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,
I am getting problem with my database(mentioned below), please give me the solution ASAP. because my production server has stoped. and I am not getting what to do. and in client side all are putting too much pressure on me.

This is Error messsage.

"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.
Satish Nagaraja
Satish Nagaraja
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 308
- Check the disk space where the .mdf .ndf or ldf files are located.
- If the disk space is full due .ldf
detach the database and add new disk
move the files there and attach the database
- This is a offline operation


Sat

Cheer Satish :-)
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
seems this is a memory problem.
please provide some more detail like size of your mdf,ldf and location of both.
configuration available.
if space is not a problem check integrity of your database.

update if you are still facing problem.

Manoj



GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86933 Visits: 45266
What does the SQL error log say? There will be a much more detailed error there. Please check the error log and post any errors relating to database Common.

This is not something that can be trivially fixed without knowing the cause.

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


GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86933 Visits: 45266
TECHBABU (4/21/2009)
- Check the disk space where the .mdf .ndf or ldf files are located.
- If the disk space is full due .ldf
detach the database and add new disk
move the files there and attach the database
- This is a offline operation


I would strongly suggest not detaching the database immediately. Depending on what the root cause is, it may happen that you detach the database and it will not reattach again.

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


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,
Thanks for your valuable response,
here i am giving some more details,

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, and

when i open the SQL server management studio and I suppose to query as
"Use common" then I am getting this problem "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.", and my applications user name and password are stored in this DB so i am not able to access the application. and beside in Object explore I am not getting +sign to explode that database, its something locked.

please give me the solution so that my application works properly.

Thanks
Sharanu.
FNS
FNS
SSC-Enthusiastic
SSC-Enthusiastic (189 reputation)SSC-Enthusiastic (189 reputation)SSC-Enthusiastic (189 reputation)SSC-Enthusiastic (189 reputation)SSC-Enthusiastic (189 reputation)SSC-Enthusiastic (189 reputation)SSC-Enthusiastic (189 reputation)SSC-Enthusiastic (189 reputation)

Group: General Forum Members
Points: 189 Visits: 584
Check the available space on your C drive, especially if the tempdb is stored on there.

Oh and if your mdf file is only 100Mb, you shouldn't have a log of 450Mb. Is the "Common" db in full mode?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86933 Visits: 45266
sharanurampur (4/21/2009)
please give me the solution so that my application works properly.


Have a look through the SQL error log. There will be more details there regarding the cause of the problem. Find those errors and post them here.

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


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
when I checked into the log files i got some message like..


2009-04-21 14:28:24.96 spid27s Starting up database 'DUMMY'.
2009-04-21 14:28:26.84 spid4s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2009-04-21 14:28:37.32 spid9s Starting up database 'tempdb'.
2009-04-21 14:28:38.59 spid4s Recovery is complete. This is an informational message only. No user action is required.
2009-04-21 14:28:38.59 spid12s The Service Broker protocol transport is disabled or not configured.
2009-04-21 14:28:38.59 spid12s The Database Mirroring protocol transport is disabled or not configured.
2009-04-21 14:28:38.76 spid12s Service Broker manager has started.
2009-04-21 14:28:45.76 spid51 Using 'xpsqlbot.dll' version '2005.90.3042' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2009-04-21 14:28:45.98 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2009-04-21 14:28:46.12 spid51 Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2009-04-21 14:41:04.84 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 1712, committed (KB): 74716, memory utilization: 2%.
2009-04-21 14:46:36.79 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 331 seconds. Working set (KB): 16892, committed (KB): 39140, memory utilization: 43%.
2009-04-21 14:51:08.57 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 603 seconds. Working set (KB): 15104, committed (KB): 36524, memory utilization: 41%.
2009-04-21 14:56:35.23 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 930 seconds. Working set (KB): 17212, committed (KB): 38988, memory utilization: 44%.
2009-04-21 15:01:07.17 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1202 seconds. Working set (KB): 15148, committed (KB): 36524, memory utilization: 41%.
2009-04-21 15:06:33.90 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1529 seconds. Working set (KB): 17200, committed (KB): 38708, memory utilization: 44%.
2009-04-21 15:11:05.84 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1801 seconds. Working set (KB): 15164, committed (KB): 36516, memory utilization: 41%.
2009-04-21 15:42:02.53 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 3657 seconds. Working set (KB): 17276, committed (KB): 38876, memory utilization: 44%.
2009-04-21 16:41:54.65 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 7249 seconds. Working set (KB): 8276, committed (KB): 38900, memory utilization: 21%.
2009-04-21 18:41:38.96 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 14434 seconds. Working set (KB): 10540, committed (KB): 38756, memory utilization: 27%.
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: 7663 Visits: 9966
Can you access the D drive on the server? Can you navigate to the folder where the mdf/ndf/ldf files exist and verify that they do in fact exist?

I have seen similar messages when there has been a network outage to the SAN. The outage was only for a second, but SQL Server lost the connection and could no longer access the drive. The only solution for this scenario was to reboot the server. I am not saying this is your problem - so don't just go and reboot the server to try and solve this problem (yet).

The errors you are getting refer to problems with memory. Are you running SQL Server 2005 Standard? Is it x64 or x86? What is the max memory setting for this instance? Are you running multiple instances on this system?

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