-
- Enthusiast
- Posts: 99
- Liked: 12 times
- Joined: Jul 23, 2012 3:48 pm
- Contact:
SQL Server Application Item Restores
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.
-
- 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
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
Joe
-
- Enthusiast
- Posts: 99
- Liked: 12 times
- Joined: Jul 23, 2012 3:48 pm
- Contact:
Re: SQL Server Application Item Restores
The user is a portal administrator. No VMs are excluded from the role.
-
- Enthusiast
- Posts: 99
- Liked: 12 times
- Joined: Jul 23, 2012 3:48 pm
- Contact:
Re: SQL Server Application Item Restores
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.
-
- 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
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.
-
- Enthusiast
- Posts: 99
- Liked: 12 times
- Joined: Jul 23, 2012 3:48 pm
- Contact:
Re: SQL Server Application Item Restores
Running v9 update 1. Updated to update 1 last night, problem still occurs.
I've been trading emails with support, case #01762623
I've been trading emails with support, case #01762623
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: May 05, 2016 11:51 am
- Contact:
[MERGED] Missing MS SQL instances in Enterprise Manager
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.
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.
-
- 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
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.
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: May 05, 2016 11:51 am
- Contact:
Re: Missing MS SQL instances in Enterprise Manager
Exactly what I mean! Yes, no error is returned and the SQL restore sub-menu is available in the windows client.
-
- 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
Known issue planned to be fixed in one of the future updates.
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: May 05, 2016 11:51 am
- Contact:
Re: SQL Server Application Item Restores
Thanks! But when you merge messages, we no longer receive notifications. It will be great to be informed when you do that.
-
- 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
This is a known issue as well. That's one of the reasons why we always encourage users to use search prior to posting.
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: May 05, 2016 11:51 am
- Contact:
Re: SQL Server Application Item Restores
I didn't find the full release note for 9.0 U2, do you know if this update solve this issue?
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: May 05, 2016 11:51 am
- Contact:
Re: SQL Server Application Item Restores
It does not seem corrected in 9.0 U2.
-
- 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
Right, it was not fixed in this update.
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: May 05, 2016 11:51 am
- Contact:
Re: SQL Server Application Item Restores
And not in the 9.5 and not in the 9.5 U1?
-
- Lurker
- Posts: 1
- Liked: 1 time
- Joined: Feb 09, 2017 8:11 am
- Contact:
Re: SQL Server Application Item Restores
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):
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
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
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
Who is online
Users browsing this forum: Egor Yakovlev, mariuszr, Semrush [Bot] and 157 guests