SQL Server Application Item Restores

Availability for the Always-On Enterprise

SQL Server Application Item Restores

Veeam Logoby nmace » Wed Apr 13, 2016 2:32 pm

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.
nmace
Enthusiast
 
Posts: 93
Liked: 12 times
Joined: Mon Jul 23, 2012 3:48 pm

Re: SQL Server Application Item Restores

Veeam Logoby jmmarton » Wed Apr 13, 2016 3:40 pm

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
jmmarton
Veeam Software
 
Posts: 817
Liked: 89 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Re: SQL Server Application Item Restores

Veeam Logoby nmace » Wed Apr 13, 2016 3:42 pm

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

Re: SQL Server Application Item Restores

Veeam Logoby nmace » Wed Apr 13, 2016 3:44 pm

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.
nmace
Enthusiast
 
Posts: 93
Liked: 12 times
Joined: Mon Jul 23, 2012 3:48 pm

Re: SQL Server Application Item Restores

Veeam Logoby foggy » Fri Apr 15, 2016 11:05 am

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.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Server Application Item Restores

Veeam Logoby nmace » Fri Apr 15, 2016 2:02 pm

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

I've been trading emails with support, case #01762623
nmace
Enthusiast
 
Posts: 93
Liked: 12 times
Joined: Mon Jul 23, 2012 3:48 pm

[MERGED] Missing MS SQL instances in Enterprise Manager

Veeam Logoby FTBZ » Tue May 24, 2016 8:38 am

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.
FTBZ
Influencer
 
Posts: 18
Liked: 2 times
Joined: Thu May 05, 2016 11:51 am

Re: Missing MS SQL instances in Enterprise Manager

Veeam Logoby v.Eremin » Tue May 24, 2016 8:55 am

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.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Missing MS SQL instances in Enterprise Manager

Veeam Logoby FTBZ » Tue May 24, 2016 8:57 am

Exactly what I mean! Yes, no error is returned and the SQL restore sub-menu is available in the windows client.
FTBZ
Influencer
 
Posts: 18
Liked: 2 times
Joined: Thu May 05, 2016 11:51 am

Re: SQL Server Application Item Restores

Veeam Logoby foggy » Tue May 24, 2016 12:16 pm 2 people like this post

Known issue planned to be fixed in one of the future updates.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Server Application Item Restores

Veeam Logoby FTBZ » Fri May 27, 2016 12:00 pm

Thanks! But when you merge messages, we no longer receive notifications. It will be great to be informed when you do that.
FTBZ
Influencer
 
Posts: 18
Liked: 2 times
Joined: Thu May 05, 2016 11:51 am

Re: SQL Server Application Item Restores

Veeam Logoby foggy » Mon May 30, 2016 4:33 pm

This is a known issue as well. ;) That's one of the reasons why we always encourage users to use search prior to posting.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Server Application Item Restores

Veeam Logoby FTBZ » Tue Aug 09, 2016 6:53 am

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

Re: SQL Server Application Item Restores

Veeam Logoby FTBZ » Wed Aug 17, 2016 12:24 pm

It does not seem corrected in 9.0 U2.
FTBZ
Influencer
 
Posts: 18
Liked: 2 times
Joined: Thu May 05, 2016 11:51 am

Re: SQL Server Application Item Restores

Veeam Logoby foggy » Fri Aug 26, 2016 3:45 pm

Right, it was not fixed in this update.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google Feedfetcher and 19 guests