[SQL] Attaching .mdf to a database, i dont have .ldf file tho.

im having trouble attaching a 3 files to 3 dbs any help? Also i need to restore the dbs.
i have tried the" ATTACH DATABASE 'filename' AS 'database' "but it does work. it says code error check Manuel.
im currently using MySQL if there is an easier program i would be happy to switch.

Create 3 New Databases by the names of Repent, Repent_Account, Repent_Log
Attach database's in enterprise manager:


Now right click on the databases and click the restore database option.
There check from device and restore –
Repent.mdf to Repent
Repent_Account.mdf to Repent_Account
Repent_Log.mdf to Repent_Log


thats my task.

thanks in advance.

does any1 even understand what i am asking?

I don't think anyone really does :P:
So. you use MySQL?
I thought it didn't have an enterprise manager.. or do you show how it is done IN enterprise manager?

well i d/l benchmark which is supposed to be like EM but i dontr know how to use any EM. im looking for a tut now. but im d/l SQL server 2005 also so i dont have to bother with MySQL.

ok i d/l MS SQL server 2005 can some1 exoplain how to get Enterprise Manager open and do this attach thing?