When i run the following command:

CREATE DATABASE HEALTHBOOKDB ON (FILENAME = N'C:\HEALTHBOOKDB\HEALTHBOOKDB.mdf') FOR ATTACH_REBUILD_LOG

I get the following error:

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\HealthBookDB.LDF" may be incorrect.

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.

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'HEALTHBOOKDB'. CREATE DATABASE is aborted.