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.

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.
ReportsupportAbilityAsked:
Who is Participating?
 
cdaly33Connect With a Mentor Commented:
Look for it here or the main Microsoft SQL Server service in the Services administration tool on the server.
SQL-Restart.jpg
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Do u have enough disk space ?
0
 
cdaly33Commented:
Are you out of disk space?  If not have you tried restarting the SQL service?
0
 
ReportsupportAbilityAuthor Commented:
Yes, there is lots of disk space.
0
 
ReportsupportAbilityAuthor Commented:
Which SQL Service do I have to restart?  Which file name?  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.