Restoring a Database to Specific Transaction via EM

[brupnick]

Good afternoon-

Is it possible to restore a database to specific transaction via Enterprise Manager? I know that it's possible through the VBR GUI and it looks as though you're able to do everything else in EM, but I don't want to have to give my DBAs access to the whole GUI when all they really need is the ability to do SQL restores.

Thank you!
Brian

[foggy]

Brian, looks like you were looking for this functionality.

[brupnick]

Hey, foggy-

I set that up to give my SQL admins access via EM, but if I load the SQL Explorer directly from the VBR console, I have a check box for "Perform restore to the specific transaction" in the Restore Wizard. Is there a comparable option through EM?

Thanks!

[foggy]

My bad, there's indeed no ability to select the specific transaction via EM, only specific point in time (so database will be restored to the closest transaction).

[brupnick]

No problem! That's the answer I was expecting, but wanted to make sure I wasn't missing a section somewhere. Are there any plans to add this functionality to EM in the future?

[foggy]

No plans at this moment, as far as I know.