SQL Plugin & Application Aware Backups

[tkutil]

We are just starting to use the SQL plugin so the DBAs can still control the SQL backups, but utilize our SOBR. The questions they have is relating to the differences in restoring DBs.
1. If a backup is created with SQL plugin can it only be recovered with the SQL plugin or can it also be recovered via the Enterprise Manager Restore portal?
2. Can backups created on one server with the SQL plugin be restored to another server with the plugin?
3. The SQL plugin seems to be heavily dependent on the user account that has the necessary rights to access the SQL DB. Would it be beneficial to have a common user account that can be configured across all of the database servers?

[PetrM]

Hi Troy,

1. Nope, the backups created by the plug-in can only be restored by the plug-in.
2. Yes, of course! Just launch the restore wizard on the target server and select the necessary backup from which you want to restore at this step.
3. That sounds reasonable, but we do not have any special recommendations. It's up to you to decide how to best handle accounts in the infrastructure. Our permissions requirements are outlined on this page.

Thanks!

[tkutil]

Sorry. More questions from the SQL DBAs. I think the DBAs are assuming that because the Veeam SQL Plugin is running within SSMS that the backup filetype it creates is .BAK like a normal SQL backup would create. Im assuming that this is not the case as I think I found the location in the repository and it appears that there are these filetypes. .VACM, .VASM, and .VAB
The folder name is Servername_Microsoft_SQL_backup_SOBR-NAME
They want to know if I can access the "BAK" files from the VBR console, but Im assuming that the Veeam SQL plugin does not create a BAK file.
Does all this sound correct?

[PetrM]

Hi Troy,

Your assumptions are correct. Additionally, exporting to .bak from .vab is on our roadmap, as we have received many requests for it.

Thanks!