Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Error 945: Inaccessible Files

Author  Topic 

jblah
Starting Member

11 Posts

Posted - 2008-06-17 : 10:16:21
Msg 945, Level 14, State 2, Line 1
Database 'Northwind' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

I keep getting that error for just trying to USE Northwind. I don't understand why this problem is occurring. It was working fine for the past few weeks. Yesterday something happened to the DB and it said something about recovery to which I accidentally clicked cancel. From then on I can't access some of the DB that I have on my computer.

I'm fairly new to the SQL Server Environment so I would appreciate any and all help that can be provided. I've google searched the details but I can't seem to get any of those to work. Thanks in advance for your reply.

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-06-17 : 12:09:17
Does this apply?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97848


Terry
Go to Top of Page

jblah
Starting Member

11 Posts

Posted - 2008-06-17 : 12:24:59
thanks. i had to reinstall SQL server..i wasn't sure what the issue was. i tried to do reattach, restore, attach none of them seemed to work. but after reinstall things seem ok. good thing it was just my personal computer.
Go to Top of Page
   

- Advertisement -