Solved

Server: Msg 945, Level 14, State 2, Line 1 Database 'fc_mdt' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.

Posted on 2009-05-15
5
1,173 Views
Last Modified: 2012-05-07
Hello.  Some of our databases is saying (Suspect).  And the jobs failed too.  When I try to run the following query, I am getting the following error message:

DBCC CHECKDB (fc_mdt) WITH NO_INFOMSGS, ALL_ERRORMSGS


Server: Msg 945, Level 14, State 2, Line 1
Database 'fc_mdt' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
0
Comment
Question by:ReportsupportAbility
  • 2
  • 2
5 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24395360
Do u have enough disk space ?
0
 
LVL 9

Expert Comment

by:cdaly33
ID: 24395366
Are you out of disk space?  If not have you tried restarting the SQL service?
0
 

Author Comment

by:ReportsupportAbility
ID: 24395421
Yes, there is lots of disk space.
0
 

Author Comment

by:ReportsupportAbility
ID: 24395491
Which SQL Service do I have to restart?  Which file name?  Thanks
0
 
LVL 9

Accepted Solution

by:
cdaly33 earned 500 total points
ID: 24395685
Look for it here or the main Microsoft SQL Server service in the Services administration tool on the server.
SQL-Restart.jpg
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now