-
- VP, Product Management
- Posts: 6035
- Liked: 2860 times
- Joined: Jun 05, 2009 12:57 pm
- Full Name: Tom Sightler
- Contact:
Re: SQL AIR
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.
AIR is used primarily for restoring individual tables/rows within a database.
-
- Enthusiast
- Posts: 48
- Liked: 1 time
- Joined: Jun 04, 2013 7:22 am
- Full Name: Atta Kat
- Contact:
Re: SQL AIR
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?
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL AIR
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.
-
- Enthusiast
- Posts: 48
- Liked: 1 time
- Joined: Jun 04, 2013 7:22 am
- Full Name: Atta Kat
- Contact:
Re: SQL AIR
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?
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL AIR
Yes, you can restore single database via FLR.
-
- Enthusiast
- Posts: 48
- Liked: 1 time
- Joined: Jun 04, 2013 7:22 am
- Full Name: Atta Kat
- Contact:
Re: SQL AIR
Thank you
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Oct 09, 2012 10:55 am
- Full Name: Andreas Stoerlein
- Contact:
Re: SQL AIR
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
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
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL AIR
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!
-
- Expert
- Posts: 167
- Liked: 4 times
- Joined: Mar 11, 2013 9:47 pm
- Contact:
Re: SQL AIR
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.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!
Thanks,
TT
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: SQL AIR
In order to restore single database, you can use Veeam FLR functionality.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?
-
- Enthusiast
- Posts: 78
- Liked: 4 times
- Joined: Jan 12, 2012 3:45 am
- Full Name: claudiofolu
- Contact:
[Merged] : Help with SQL item restore
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?
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?
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: SQL AIR
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.
Thanks.
-
- Enthusiast
- Posts: 78
- Liked: 4 times
- Joined: Jan 12, 2012 3:45 am
- Full Name: claudiofolu
- Contact:
Re: SQL AIR
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
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
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: SQL AIR
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.
Thanks.
Who is online
Users browsing this forum: No registered users and 10 guests