SQL database restore failed Possible Duplicate:
  SQL database restore failed  




I have a c# application that is connected to my sql server 2005 database, i am working on the application to insert some entries in the database and due to power failure system got down and from that time onwards i am getting this error. I refresh the database, make a copy of it, delete it &amp; try to attach it again and thus the error occurs.


  The log cannot be rebuilt because there were open transactions/users
  when the database 
      was shutdown, no checkpoint occurred to the database, or the database was read-only. This  error could occur if the transaction log
  file was manually deleted or lost due to a hardware  or environment
  failure.


If i use the log file while attaching the db, i got this error


  The log scan number (1224:41:1) passed to log scan in database 'test' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Are you copying the mdf/ldf files with SQL Server running? That will almost never give you a usable copy, unless there are no writes to either file during the entire copy process. Either stop SQL Server or detatch the database before copying the files.