I'm trying to attach Yafnet.mdf in SQL Server Management Studio, which does not have a log file.

I get the error below. Any ideas how this can be done?

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Unable to open the physical file "C:\sql_logs\YAFnet_log.ldf". Operating system error 2: "2(The system cannot find the file specified.)". (Microsoft SQL Server, Error: 5120)

sql sql-server sql-server-2008
Edit
Report