Unable to attach the database

I had to detach the database to delete the transaction log as it took
the hole disk space.

No I am trying to attach database, however I am not able to do so.

The engine is asking me whether I want to continue and create new log
file. I agree to it, however then I am receiving an error:

Error 1813: Could not open new database 'db_name'. CREATE DATABASE
aborted. Device activation error. The physical file name 'E:\SQL
Databases\MSSQL\Data\db_name.ldf' may be incorrect.

Then after I have message than attaching database failed.

In event viewer I have:

17204 :
FCB::Open failed: Could not open device E:\SQL Databases\MSSQL\Data
\db_name.MDF for virtual device number (VDN) 0.

In the error log I have:
2008-01-23 10:28:59.00 spid52 Starting up database 'db_name'.

Do you have any ideas where the problem is?

I have never had this problem before, only now. And I didn't have this
problem with other databases for which I have deleted the log file.
.

Relevant Pages

  • Re: VSS 800423f4 error after Sharepoint backup test
    ... instructions to delete the STS_RESTORE database! ... SBS Backup failing if you don't do this deletion (or the instructions ... >Enterprise Manager and then the recovery model can be changed to Simple. ... On the Attach Database page, ...
    (microsoft.public.windows.server.sbs)
  • System.Data.SqlClient.SqlException: CREATE DATABASE
    ... I was able to resolve the below issue. ... >CREATE DATABASE permission denied in database 'master'. ... >Could not attach database 'Contacts' to ...
    (microsoft.public.cert.exam.mcad)
  • System.Data.SqlClient.SqlException: CREATE DATABASE
    ... CREATE DATABASE permission denied in database 'master'. ... Could not attach database 'Contacts' to ... execution of the current web request. ...
    (microsoft.public.cert.exam.mcad)
  • Re: copy a database from server to development
    ... there is "Copy database wizard". ... Detach and Attach database ... Backup and Restore the database ...
    (microsoft.public.sqlserver.server)
  • attaching database
    ... I 'm trying to attach a database to my local SQL server. ... on Database -> all tasks -> Attach Database. ... mdf file but two red crosses appear over the files I want to import. ...
    (microsoft.public.sqlserver.server)