STOPATMARK option

  • Dear Experts

    restoring to a mark is failed by using Management studio

    1- i made a full backup in full recovery for Adventureworks 2012

    2- i inserted some data

    3- i created a transaction with mark ( begin tran test1 with mark )

    4- i inserted some data

    5- i made a log backup

    6- i deleted the database

    7- i restored db from device for full backup only with NORECOVERY option

    8- i run this query select * from msdb ..logmarkhistory, then i found my mark

    -------------------

    9- i am trying to restore the Transaction log file but when i check the radio button "Marked transaction" the grid is empty , why

    what i am missing to show the marked transaction in the grid?

    Thanks lot

Viewing 0 posts

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