SQL2005 Log File Issue..

[DLu]

All DBs on SQL2005 C:\ drive are ok, all DBs on another drive X: are in suspect mode and could not access them.

Finally, buy using detach and attach, I am able to recover one important DB. However, the attach method via Management Studio only provide the xxxx.mdf but not available the xxxx.ldf.

The data is recovered, but I need the log to be ready to A/D/C.
thanks
-D

[DLu]

One more thing:

sp_helpdb DBxyz
displayed the DBxyz_log
field:2
fileName: G:\data\dbxyz_log.ldf
fileGroup: Null
size: 20480 kb

My understanding is fileGroup: Null is the same as no log?
And if it is correct, how to change the fileGroup: Null to Primary?

thanks
-D

[rmiao]

Log file doesn't belong to any file group, that's why you get null. Can sql see g:\ drive?

[mohamedhammad]

u can remove the log file from the attach database dialog and sql server will create another on for u this will work if you need data in the mdf file.
may be it will work.