• sachin-355820 (11/9/2010)


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

    1)Take a Tail log backup.

    Database has been detached so log file wont be available.

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

    No need to create a new database. Restore will be just fine.

    3)Restore the Tail log backup.

    All subsequent log backups taken after full backup need to be restored in sequence first before restoring tail log backup(if that is available, in this case it is not)



    Pradeep Singh