Hi,
The company I've recently joined is in the process of switching over to using Veeam for all backups. I was wondering if anyone had any experience of working with Veeam and their "Explorer for SQL Server". I'm specifically interested in how to restoring a database following a corruption of the database, in other words restoring to a "clean" database and applying all the logs to recover to "now"?
I have tried the Veeam forum, but I'm not confident with the response I've had back. A Veeam restore point seems to cover 3 full database backups (or 2 for the most "current" restore point) and all the log backups in between. My concern is that when we want to restore to a clean database and apply all the transaction logs to get us back to "now", we have no control that Veeam's "Explorer for SQL Server" will use the "clean" full backup and will rather use the most recent and possibly "corrupt" one.
So I was hoping that someone else is using Veeam and already has an answer.
Thanks in advance.