ApexSQL Log - How do I find the LastLSN after a database restore?

We are using ApexSQL Log to replicate some databases, where we create Redo scripts that get executed against the subscriber database.

We are using Continuous mode, which stores the LastLSN that was logged/replicated in a file.

Once in a while, there is an issue with a redo script that causes transactions to be lost.  This requires us to backup the origin database and restore it to the server where we are replicating to, then restart the ApexSQL Log software.

At this point, we have to update the LastLSN value in our Database.AXTR file.

What is the easiest way to get the LastLSN to put in the file so that it matches the last transaction that is in the database backup file we just restored with?

Thank you,


Parents Reply Children
No Data