• There are two ways to recover a single data file DB in SQL 2005.

    1. Create DB for attach ...

    CREATE DATABASE database_name

    ON [ ,...n ]

    FOR { ATTACH [ WITH ]

    | ATTACH_REBUILD_LOG }

    2. If the log was lost during SQL server is down, once you start the sql server, a new log file will be generated automaticly.