Attach MDF file without LDF file
From few days ago i have a problem which is i lost my
log file of sql server 2000. Then I tried to recover it then failed. Sql server
2000 cannot attach db without LDF log file. Then I search this problem on Google
and found a solution
Attach your MDF file with Sql server 2005 and when you attaching then remove
LDF file from list of Sql server 2005. Then you will see Sql server 2005
generate LDF file automatically. Then if you want to that database convert
again to Sql server 2000 then use import/Export utility of Sql Server 2000
because you can use Sql Server Import/Export with Both 2000/2005.