• Back up the tail of your transaction log...

    is it this one?

    BACKUP DATABASE [PMSdb]

    TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb.bak'

    WITH NOFORMAT, NOINIT, NAME = N'PMSdb-Full Database Backup',

    SKIP, NOREWIND, NOUNLOAD, STATS = 10

    GO

    but the result is...

    Msg 3033, Level 16, State 0, Line 1

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

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    from table sysdatabases, PMSdb status is 4194328 not 32768 (emergency mode)