How to Attach a database without a transaction log file (.ldf)

If you ever lose the drive that contains your log file, your database will become suspect and will stop working. You do not need to restore the backup in such a crash. If you do, you will lose everything since your last BACKUP. All you have to do is to detach the database and reattach it without the log. SQL Server 2005 does allow you to do this. You can reattach the database by following these simple steps...