Posted by Erland Sommarskog on 06/13/06 21:46

R.A.M. (r_ahimsa_m@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]