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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

708 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

11 Experts available now in Live!

Get 1:1 Help Now