Tail of the Log

  • Is it possible to take a backup of the tail of the log through MSMS rather than through Transact SQL ? If so how ?

  • It's possible.

    Just select in the General tab: backup log: transaction log and in Options tab select "Back up the tail of the log, and leave the database in the restoring state".

    Regards,

    Jose Santiago Oyervides.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply