2005: Database cannot be opened

[R.A.M.]

Hello,
Could you explain me please the following error:

"Database 'DemoDotNET' cannot be opened due to inaccessible files or
insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"

I have checked: free disk space is large enough, I have much enough
memory, other files in the directory are accessible.

Here is tail of ERRORLOG:

2006-06-12 21:19:55.68 Logon Error: 18456, Severity: 14, State:
16.
2006-06-12 21:19:55.68 Logon Login failed for user 'PC\Robert'.
[CLIENT: <local machine>]
2006-06-12 21:20:43.39 Server Server resumed execution after
being idle 1 seconds: user activity awakened the server. This is an
informational message only. No user action is required.

Please help to solve this.
Thank you.
/RAM/

[Erland Sommarskog]

R.A.M. (r_********@poczta.onet.pl) writes:

"Database 'DemoDotNET' cannot be opened due to inaccessible files or
insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"

I have checked: free disk space is large enough, I have much enough
memory, other files in the directory are accessible.

Or there is some file for DemoDotNET which is located somewhere where
you don't think it is.

Unfortunately, with the information at hand it's impossible to say. You
could at least have posted the part of the error log where this message
appears. Or tell us when you get this error. Does it happen at startup?
Do you try to attach the database? Something else?

And, not the least, you did not tell us which version of SQL Server
you are using.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[R.A.M.]

On Mon, 12 Jun 2006 21:36:15 +0000 (UTC), Erland Sommarskog
<es****@sommarskog.se> wrote:

R.A.M. (r_********@poczta.onet.pl) writes:

"Database 'DemoDotNET' cannot be opened due to inaccessible files or
insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"

I have checked: free disk space is large enough, I have much enough
memory, other files in the directory are accessible.

Or there is some file for DemoDotNET which is located somewhere where
you don't think it is.

Unfortunately, with the information at hand it's impossible to say. You
could at least have posted the part of the error log where this message
appears. Or tell us when you get this error. Does it happen at startup?
Do you try to attach the database? Something else?

And, not the least, you did not tell us which version of SQL Server
you are using.

I am using SQL Server 2005.
In directory of the database I have files: DemoDotNET.mdf,
DemoDotNET_log.ldf.
I got the error when I try to see properties of database, or script
database or open in C#.NET or VB program.

[Erland Sommarskog]

R.A.M. (r_********@poczta.onet.pl) writes:

I am using SQL Server 2005.
In directory of the database I have files: DemoDotNET.mdf,
DemoDotNET_log.ldf.
I got the error when I try to see properties of database, or script
database or open in C#.NET or VB program.

If you do

SELECT name, physical_name
FROM sys.master_files
where database_id = db_id('DemoDotNet')

does physical_name agree with the files you see in Explorer?

If they do, my suspicion is that the log file has been tampered with,
and is not usable.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx