• Is the last full backup and log file available.If yes then you need to

    1)Take a Tail log backup.

    2)Create a new database and then restore the full backup.

    3)Restore the Tail log backup.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server