topic Re: SMSQL 7.0 Marked Transactions Not Showing in Data Protection

SMSQL 7.0 Marked Transactions Not Showing

Fred_White — Thu, 05 Jun 2025 05:24:25 GMT

Newbie to the forums and to the tool, so perhaps this is an easy fix.

We've got the tool up and running seemingly fine. We've run multiple backups with transaction logs, I'm seeing the logs, and I can even opt to do point in time restores. However, if I select the option to go for specific transactions to choose, no transactions are ever showing. I've tried this across multiple databases and multiple backups. I can always see the DB backups and the transaction logs, but there are never any transactions listed in the Select Marked Transaction pop up even when I see a transaction range of multiple days in which I know there have been lots of changes to the database.

Any ideas why specific transactions would not be listed on that pop up?

Re: SMSQL 7.0 Marked Transactions Not Showing

deepuj — Tue, 18 Nov 2014 10:45:33 GMT

Hi,

You can use either restore to mark or restore to point-in-time. They do not work simultaneously.

Thanks

Re: SMSQL 7.0 Marked Transactions Not Showing

Fred_White — Tue, 18 Nov 2014 13:16:54 GMT

Thank you for the response.

I'm not trying to use both simultaneously, I'm simply trying to see ANY transactions in the Select Marked Transaction screen, and none appear at all. I only mentioned that the point in time option gives me a valid date and time range to show that I do have transaction logs and the restore tool appears to be recognizing them...but when I deselect point in time and select specific transaction, no transactions are listed.

Re: SMSQL 7.0 Marked Transactions Not Showing

deepuj — Wed, 19 Nov 2014 16:52:06 GMT

Hi,

In order to see the marked transaction log you should first take a federated backup.

Hope this helps!

Thanks

Re: SMSQL 7.0 Marked Transactions Not Showing

Fred_White — Fri, 21 Nov 2014 13:37:28 GMT

Thank you for pointing me in this direction. After reading more carefully about Federated Backups and Marked Transactions, I now understand the functionality much more clearly and have it working properly.