SQL Server Application Item Restores

[nmace]

I've got a SQL Server running as a VM. It gets backup by Veeam nightly. Using the Windows Veeam Console if I do an application restore->SQL Server it shows up in the list of available items. However if I login to Enterprise Manager as the same user and try to do a SQL Item Restore, that VM is not in the list of available items to pick. Why is there a difference? The VM was successfully backed up last night.

[jmmarton]

How are the roles defined in Enterprise Manager? Does this user have the Allow restore of Microsoft SQL Server databases permission? If so, what is the restore scope? Is this VM excluded from the scope?

Joe

[nmace]

The user is a portal administrator. No VMs are excluded from the role.

[nmace]

I've also tried it as a different user that is a restore operator with restore access to "all vms" as well as SQL Servers. It sees the same thing. It sees some SQL VMs, but not all of them that show up in with Windows console.

[foggy]

Are you running Veeam B&R v9? There's another similar report that is being investigated by our support, so if you open your own case, it will probably help in tracking the issue down. Thanks.

[nmace]

Running v9 update 1. Updated to update 1 last night, problem still occurs.

I've been trading emails with support, case #01762623

[FTBZ]

Hello,

We've a few MS SQL servers backed up by Veeam, the restore operations are working fine through the Windows client, but some servers are not available in the Enterprise Manager portal.

An idea why these instances do not appear in the web client (with administrator role)?

Thanks.

[veremin]

Just to be sure - you mean you cannot see them under "Items" -> SQL tab? If so, are you positive these instances have been processed successfully with Application Aware Image Processing option enabled? Thanks.

[FTBZ]

Exactly what I mean! Yes, no error is returned and the SQL restore sub-menu is available in the windows client.

[foggy]

Known issue planned to be fixed in one of the future updates.

[FTBZ]

Thanks! But when you merge messages, we no longer receive notifications. It will be great to be informed when you do that.

[foggy]

This is a known issue as well. That's one of the reasons why we always encourage users to use search prior to posting.

[FTBZ]

I didn't find the full release note for 9.0 U2, do you know if this update solve this issue?

[FTBZ]

It does not seem corrected in 9.0 U2.

[foggy]

Right, it was not fixed in this update.

[FTBZ]

And not in the 9.5 and not in the 9.5 U1?

[ASmagin]

I`ve investigated same issue:
For some VMs SQL DBs also were not visible through Enterprise Manager Portal. Also those DBs not returned by Veeam Powershell (as it should):

Code: Select all

$restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "YOURSQLVM" 
Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[0] | ft servername, name

Result was null.

Despite results of backup job were successful, In backup job logs (located C:\ProgramData\Veeam\Backup\_JOBNAME_) I`ve found error for AAIP account: "Win32 error:Logon failure: the user has not been granted the requested logon type at this computer."
2 reasons for such error:
1) account for AAIP was denied for logon locally (by GPO) - similar issue here
2) account for AAIP doesn`t have sysadmin role permissions on SQL (add.info - here)

After I`ve granted sysadmin role permissions and allow logon locally for AAIP account, SQL databases became visible in Enterprise Manager Portal, and veeam powershell now returns DBs correctly

Hope, this workaround helps you