Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
atta
Enthusiast
Posts: 48
Liked: 1 time
Joined: Jun 04, 2013 7:22 am
Full Name: Atta Kat
Contact:

SQL AIR

Post by atta » 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?

tsightler
VP, Product Management
Posts: 5374
Liked: 2209 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: SQL AIR

Post by tsightler » 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.

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

Re: SQL AIR

Post by atta » 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?

foggy
Veeam Software
Posts: 18024
Liked: 1530 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL AIR

Post by foggy » 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.

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

Re: SQL AIR

Post by atta » 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?

foggy
Veeam Software
Posts: 18024
Liked: 1530 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL AIR

Post by foggy » Sep 12, 2013 2:35 pm 1 person likes this post

Yes, you can restore single database via FLR.

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

Re: SQL AIR

Post by atta » Sep 12, 2013 2:43 pm

Thank you

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

Re: SQL AIR

Post by stoerlein_a » 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

foggy
Veeam Software
Posts: 18024
Liked: 1530 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL AIR

Post by foggy » 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!

trackstar
Expert
Posts: 138
Liked: 2 times
Joined: Mar 11, 2013 9:47 pm
Contact:

Re: SQL AIR

Post by trackstar » 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

Vitaliy S.
Product Manager
Posts: 22747
Liked: 1518 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL AIR

Post by Vitaliy S. » 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.

claudiofolu
Enthusiast
Posts: 48
Liked: 2 times
Joined: Jan 12, 2012 3:45 am
Full Name: claudiofolu
Contact:

[Merged] : Help with SQL item restore

Post by claudiofolu » 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?

veremin
Product Manager
Posts: 16666
Liked: 1390 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL AIR

Post by veremin » 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.

claudiofolu
Enthusiast
Posts: 48
Liked: 2 times
Joined: Jan 12, 2012 3:45 am
Full Name: claudiofolu
Contact:

Re: SQL AIR

Post by claudiofolu » 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

veremin
Product Manager
Posts: 16666
Liked: 1390 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL AIR

Post by veremin » 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.

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests