SQL AIR

Hyper-V specific discussions

SQL AIR

Veeam Logoby atta » Wed Sep 11, 2013 12:10 pm

Hi,
Is AIR for SQL working in veeam 7? Hope that it will be posibble to restore individual databases in SQL with AIR in this version for Hyper-V and how to restore without using virual lab?
atta
Enthusiast
 
Posts: 48
Liked: 1 time
Joined: Tue Jun 04, 2013 7:22 am
Full Name: Atta Kat

Re: SQL AIR

Veeam Logoby tsightler » Wed Sep 11, 2013 12:30 pm

If you're just wanting to restore the entire individual database you really don't need AIR at all. Just use SQL Management Studio to take the database offline, determine which files are used by this database (easily found in the Database Properties...Files menu), and then perform an FLR of the MDF and LDF files. Then bring the DB online.

AIR is used primarily for restoring individual tables/rows within a database.
tsightler
Veeam Software
 
Posts: 4768
Liked: 1737 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SQL AIR

Veeam Logoby atta » Wed Sep 11, 2013 12:51 pm

Thanks for the replay. But is it posibble to use AIR if I have 100 databases can I restore one with veeam and how to restore it without virtual lab?
atta
Enthusiast
 
Posts: 48
Liked: 1 time
Joined: Tue Jun 04, 2013 7:22 am
Full Name: Atta Kat

Re: SQL AIR

Veeam Logoby foggy » Wed Sep 11, 2013 1:15 pm

As Tom has already mentioned, you can restore individual databases using native FLR of the corresponding files. No AIR (and hence, virtual lab) is required in this case.
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL AIR

Veeam Logoby atta » Thu Sep 12, 2013 2:30 pm

Thanks for info but veeam can restore single databases (not talking here about AIR) if needed not whole server or? If I want to restore with Veeam to original/separete location can I do it?
atta
Enthusiast
 
Posts: 48
Liked: 1 time
Joined: Tue Jun 04, 2013 7:22 am
Full Name: Atta Kat

Re: SQL AIR

Veeam Logoby foggy » Thu Sep 12, 2013 2:35 pm 1 person likes this post

Yes, you can restore single database via FLR.
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL AIR

Veeam Logoby atta » Thu Sep 12, 2013 2:43 pm

Thank you
atta
Enthusiast
 
Posts: 48
Liked: 1 time
Joined: Tue Jun 04, 2013 7:22 am
Full Name: Atta Kat

Re: SQL AIR

Veeam Logoby stoerlein_a » Tue Oct 08, 2013 3:14 pm

I cannot understand that there is no more professional SQL Backup and restore Utility.

The possibilities of the U-Air-Wizard does not fit to Enterprise Needs. Why there is not a nice GUI like the Exchnage or SharePoint Wizard with all Features (like Tivoli TSM for SQL or the native SQL BAckup)

This makes us headaches...

Andi
stoerlein_a
Lurker
 
Posts: 1
Liked: never
Joined: Tue Oct 09, 2012 10:55 am
Full Name: Andreas Stoerlein

Re: SQL AIR

Veeam Logoby foggy » Tue Oct 08, 2013 4:16 pm

Andreas, we've already got a number of requests for implementing similar functionality for SQL Server granular restore, so this feature is definitely on our radar. Thanks for the feedback, anyway. Much appreciated!
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL AIR

Veeam Logoby trackstar » Thu Jan 16, 2014 7:23 pm

foggy wrote:Andreas, we've already got a number of requests for implementing similar functionality for SQL Server granular restore, so this feature is definitely on our radar. Thanks for the feedback, anyway. Much appreciated!


I have been trying to do a restore using AIR and just noticed that single database restore with AIR isn't supported. For FLR restore, that means the native sql backup has to be used right? Just confirming.

Thanks,
TT
trackstar
Expert
 
Posts: 126
Liked: never
Joined: Mon Mar 11, 2013 9:47 pm

Re: SQL AIR

Veeam Logoby Vitaliy S. » Thu Jan 16, 2014 9:42 pm

trackstar wrote:I have been trying to do a restore using AIR and just noticed that single database restore with AIR isn't supported. For FLR restore, that means the native sql backup has to be used right?

In order to restore single database, you can use Veeam FLR functionality.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

[Merged] : Help with SQL item restore

Veeam Logoby claudiofolu » Mon Jan 20, 2014 8:20 pm

Hello,
I need some advice on a SQL restore. We are using Veeam 7.0 R2 to backup our SQL Server 2008 VMs. We follow the configuration guides, create the virtuallab, appliacation group, all went smooth, but when we raun the SQL Application Item Restore, in the wizard when we browse for the SQL Server, nothing shows up.
We have a couple of backups for this machine, so we are lost.

Any clues?
claudiofolu
Enthusiast
 
Posts: 42
Liked: 1 time
Joined: Thu Jan 12, 2012 3:45 am
Full Name: claudiofolu

Re: SQL AIR

Veeam Logoby v.Eremin » Tue Jan 21, 2014 11:13 am

Hi, I'm wondering whether you want to restore entire database or individual items. I'm asking since if your goal is to restore entire database, you can use FLR restore, instead of U-AIR.

Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL AIR

Veeam Logoby claudiofolu » Tue Jan 21, 2014 2:18 pm

Hi, thanks for your reply.
We want to restore an individual item (tables). The question is why the SQL servers are not showing when we hit the Browse button in the AIR wizard
claudiofolu
Enthusiast
 
Posts: 42
Liked: 1 time
Joined: Thu Jan 12, 2012 3:45 am
Full Name: claudiofolu

Re: SQL AIR

Veeam Logoby v.Eremin » Tue Jan 21, 2014 2:21 pm

If you've followed the corresponding procedure correctly, and SQL server doesn't show up, then, the best way will be to open a case with the support team and let them investigate it directly.

Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 6 guests