• when i run this...

    backup log PMSdb

    to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.trn'

    with NO_TRUNCATE

    Server: Msg 3033, Level 16, State 1, Line 1

    BACKUP DATABASE cannot be used on a database opened in emergency mode.

    Server: Msg 3013, Level 16, State 1, Line 1

    BACKUP LOG is terminating abnormally.

    i have no backup log...

    FYI, my database (PMSdb.mdf) was corrupted before this when i attach database and the result is...

    Error823: I/O error (bad page ID) detected during read at offset 0x000000e1b78000 in file

    'D:\Program Files\Microsoft SQL Server\MSSQL\DATA\PMSdb.mdf'.

    actually, what is the correct step?