Comprehensive data protection for all workloads
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Howto restore SQL Table Veeam8

Post by foggy »

Ilya, what Veeam B&R version are you at? This is possible with SQL AIR Wizard in v7, however starting v8 you should contact technical support to get the compatible version of the tool.
JayJohnNewelly
Lurker
Posts: 2
Liked: never
Joined: Apr 15, 2015 10:17 am
Full Name: Jay John Newell
Contact:

[MERGED] Restoring Exchange 2007 Items and Veeam 8

Post by JayJohnNewelly »

Hi there,

I have Exchange 2007 running in a VM and Veeam 8 is currently being used to back it up. I am aware that the Exchange Explorer is not compatible with Exchange 2007 and I wondered what the simplest method of restoring individual items from Exchange 2007 is. I can see the U-Air wizard should be able to do it and I have installed the Univeral AIR tool from the Veeam 8 installation media which allows me to build a lab to mimic the production environment and restore from there. In Veeam 7 the Exchange AIR wizard was available but I can't seem to find this in Veeam 8. Is there a way I can restore Exchange 2007 items without having to create a lab etc.

Thanks

Jay
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Howto restore SQL Table Veeam8

Post by Shestakov »

Hi Jay,
You are right, starting from v8 Veeam doesn`t market AIR wizards in a favor of Veeam Explorer.
However, you can get a v8-compatible application-specific AIR wizard contacting Veeam Support Team or using this link.
If you want to use Veeam Explorer for Exchange, you need to update to a newer version of Microsoft Exchange Server, since Exchange 2007 is not supported.
Thanks.
JayJohnNewelly
Lurker
Posts: 2
Liked: never
Joined: Apr 15, 2015 10:17 am
Full Name: Jay John Newell
Contact:

Re: Howto restore SQL Table Veeam8

Post by JayJohnNewelly »

Thanks very much for your reply. It's handy to know that I can get my hands on the Exchange AIR wizard for Veeam 8. I'll give this a go.
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Howto restore SQL Table Veeam8

Post by Shestakov »

You are welcome, Jay. Once you have a question, don`t hesitate asking!
coopsam
Influencer
Posts: 21
Liked: never
Joined: Apr 30, 2014 11:48 am
Full Name: Sam Cooper
Contact:

Re: Howto restore SQL Table Veeam8

Post by coopsam »

Can I ask what the process is now for restoring a single DB to a different location as in order to do this I have to restore the whole VM, copied the files to a new VMDK, attached the VMDK to recovery VM and copied files onto the production network for the user, seems a little long winded. Plus all of my support documentation was done using veeam 7 which now doesn't work if followed.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Howto restore SQL Table Veeam8

Post by foggy »

Sam, have you considered using Veeam Explorer for SQL Server for that purpose?
coopsam
Influencer
Posts: 21
Liked: never
Joined: Apr 30, 2014 11:48 am
Full Name: Sam Cooper
Contact:

Re: Howto restore SQL Table Veeam8

Post by coopsam »

Yes I tried first to use Veeam Explorer for SQL but I could not work out the settings for the add database. I used sure restore and the application group to mount the server in the lab but I would not work out how from there how to add it into the SQL explorer. Most likely I am missing something here.

Is there a single KB which show end to end how to restore a single database to both original and new locations?

I really need to sort this out as it means all my support docs for the BAU teams are now out of date when they need to restore SQL db's or do single item exchange restores.

Please help :)
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Howto restore SQL Table Veeam8

Post by veremin »

Have you checked the corresponding section of our Help Center already? Thanks.
coopsam
Influencer
Posts: 21
Liked: never
Joined: Apr 30, 2014 11:48 am
Full Name: Sam Cooper
Contact:

Re: Howto restore SQL Table Veeam8

Post by coopsam »

Yes I have had a look at that and the part I am missing is how to get a server to browse. I'll raise a support call if needed so you chaps can take a look and show me what I am doing wrong and then I can document is properly.

Thanks :)
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Howto restore SQL Table Veeam8

Post by foggy »

If your backup job has application-aware image processing enabled, you can start recovery by right-clicking the backup and selecting corresponding command. Alternatively, you can first use FLR to extract the database file and then add it to Veeam Explorer for SQL Server for browsing.
marioschaper
Lurker
Posts: 1
Liked: never
Joined: May 05, 2015 9:37 am
Full Name: Mario Schaper
Contact:

[MERGED]: Backup & Restore Exchange 2007 with B&R V8

Post by marioschaper »

Hi,

we are using Exchange 2007 SP3 and want to backup & restore it with Veeam B&R.
Especially we want to use Application Item Restore for Exchange 2007 SP3.
Can someone please tell me what the best practice for this constellation is?
Thanks

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

Re: Howto restore SQL Table Veeam8

Post by veremin » 1 person likes this post

Hi, Mario, You should open a ticket with our support ticket and request Exchange U-AIR wizard compatible with VB&R v8. Thanks.
ChrisGundry
Veteran
Posts: 258
Liked: 40 times
Joined: Aug 26, 2015 2:56 pm
Full Name: Chris Gundry
Contact:

[MERGED] SQL Item Level Restore - SQL Explorer

Post by ChrisGundry »

Hi There,

I have used Veeam for many years and I really like the Exchange restore wizard/explorer. I like the fact that you can do a full item level restore from this wizard and it is very easy.

However, the SQL wizard cannot do the same thing. It mounts the backup file then allows you to restore a whole database or nothing. To do anything further you need to setup sure backup, application groups,VpowerNFS etc and get them all working, then request the SQL-Air wizard from support, install and setup that. Then get all this working and test it. Just to restore a table/row from a SQL database.

So, my question is:
Is there a technical reason why we cannot have the same functionality as the Exchange explorer for the SQL explorer?
Is there a plan to change this functionality?

Many thanks!

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

Re: SQL Item Level Restore - SQL Explorer

Post by foggy »

Chris, table-level recovery will be included in Veeam Explorer for SQL Server coming with Veeam B&R v9, along with other enhancements. Thanks.
ChrisGundry
Veteran
Posts: 258
Liked: 40 times
Joined: Aug 26, 2015 2:56 pm
Full Name: Chris Gundry
Contact:

Re: Howto restore SQL Table Veeam8

Post by ChrisGundry »

Thanks for coming back to be foggy. Can you please confirm if it is just table level recovery, or will it also include the query type recovery method as per the SQL-AIR application?
Thanks!
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Howto restore SQL Table Veeam8

Post by foggy » 1 person likes this post

You will be able to restore everything you can restore with SQL AIR.
ChrisGundry
Veteran
Posts: 258
Liked: 40 times
Joined: Aug 26, 2015 2:56 pm
Full Name: Chris Gundry
Contact:

Re: Howto restore SQL Table Veeam8

Post by ChrisGundry »

That is great news! Thanks foggy
brink668
Novice
Posts: 3
Liked: never
Joined: Aug 30, 2015 4:02 pm
Full Name: brink668
Contact:

Re: Howto restore SQL Table Veeam8

Post by brink668 »

Just saying that table level recovery feature will be a great addition to the SQL Server recovery explorer wizard.

Just wondering as I am a relatively new customer if I have Veeam 8 and version 9 comes out and my support level is within the timeframe of release would I be eligible to upgrade to B&R v9 when it comes out? (i know this is early)
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Howto restore SQL Table Veeam8

Post by veremin »

Yep, if you're on actual support at the time of release, upgrade will be provided free of charge. Thanks.
BCT-Tech
Service Provider
Posts: 78
Liked: 1 time
Joined: Mar 20, 2015 6:12 pm
Contact:

Re: SQL Item Level Restore - SQL Explorer

Post by BCT-Tech »

foggy wrote:Chris, table-level recovery will be included in Veeam Explorer for SQL Server coming with Veeam B&R v9,
We have not upgraded to v9 yet. Is this table-level recovery included and working well?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Howto restore SQL Table Veeam8

Post by foggy »

Post Reply

Who is online

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