Comprehensive data protection for all workloads
Post Reply
nmace
Enthusiast
Posts: 99
Liked: 12 times
Joined: Jul 23, 2012 3:48 pm
Contact:

SQL Server Application Item Restores

Post by 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
Veeam Software
Posts: 2097
Liked: 310 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: SQL Server Application Item Restores

Post by 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
Enthusiast
Posts: 99
Liked: 12 times
Joined: Jul 23, 2012 3:48 pm
Contact:

Re: SQL Server Application Item Restores

Post by nmace »

The user is a portal administrator. No VMs are excluded from the role.
nmace
Enthusiast
Posts: 99
Liked: 12 times
Joined: Jul 23, 2012 3:48 pm
Contact:

Re: SQL Server Application Item Restores

Post by 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
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Server Application Item Restores

Post by 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
Enthusiast
Posts: 99
Liked: 12 times
Joined: Jul 23, 2012 3:48 pm
Contact:

Re: SQL Server Application Item Restores

Post by nmace »

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

I've been trading emails with support, case #01762623
FTBZ
Influencer
Posts: 22
Liked: 2 times
Joined: May 05, 2016 11:51 am
Contact:

[MERGED] Missing MS SQL instances in Enterprise Manager

Post by 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
Product Manager
Posts: 20400
Liked: 2298 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Missing MS SQL instances in Enterprise Manager

Post by 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
Influencer
Posts: 22
Liked: 2 times
Joined: May 05, 2016 11:51 am
Contact:

Re: Missing MS SQL instances in Enterprise Manager

Post by FTBZ »

Exactly what I mean! Yes, no error is returned and the SQL restore sub-menu is available in the windows client.
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Server Application Item Restores

Post by foggy » 2 people like this post

Known issue planned to be fixed in one of the future updates.
FTBZ
Influencer
Posts: 22
Liked: 2 times
Joined: May 05, 2016 11:51 am
Contact:

Re: SQL Server Application Item Restores

Post by FTBZ »

Thanks! But when you merge messages, we no longer receive notifications. It will be great to be informed when you do that.
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Server Application Item Restores

Post by 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
Influencer
Posts: 22
Liked: 2 times
Joined: May 05, 2016 11:51 am
Contact:

Re: SQL Server Application Item Restores

Post by FTBZ »

I didn't find the full release note for 9.0 U2, do you know if this update solve this issue?
FTBZ
Influencer
Posts: 22
Liked: 2 times
Joined: May 05, 2016 11:51 am
Contact:

Re: SQL Server Application Item Restores

Post by FTBZ »

It does not seem corrected in 9.0 U2.
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Server Application Item Restores

Post by foggy »

Right, it was not fixed in this update.
FTBZ
Influencer
Posts: 22
Liked: 2 times
Joined: May 05, 2016 11:51 am
Contact:

Re: SQL Server Application Item Restores

Post by FTBZ »

And not in the 9.5 and not in the 9.5 U1? :roll: :shock:
ASmagin
Lurker
Posts: 1
Liked: 1 time
Joined: Feb 09, 2017 8:11 am
Contact:

Re: SQL Server Application Item Restores

Post by ASmagin » 1 person likes this post

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
Post Reply

Who is online

Users browsing this forum: Egor Yakovlev, mariuszr, Semrush [Bot] and 157 guests