hi expert
i created a database with test Name (test.MDF)
but forchenatly i lost the test_Log.LDF
then when i wanna to attach my database to enter prise manager i recive th fllowing error
help me thans
 the error is :

Could not open new database 'test'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'F:\mehdi\test_Log.LDF' may be incorrect.
regards

Try this...

1) copy the test.MDF file to somewhere.
2) Create a new database with name "test" under the same path 'F:\mehdi'
3) Now stop SQL server service and Copy the original test.MDF file from the other location to overwrite the one under 'F:\mehdi', and dont disturb "test_Log.LDF".
4) Start Sql Server service You may get through...

Cheers.

_________________________
- Vijay G
Strive for Perfection