?
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
Medium Priority
?
1,365 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 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

864 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