Restore MSSQL when backing up directly to Cloud Connect

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

Restore MSSQL when backing up directly to Cloud Connect

Veeam Logoby wsellers » Mon Jul 24, 2017 2:33 pm

Hey everyone,

In my lab, I am backing up a Microsoft Windows Server w/MSSQL. The VAW is backing up directly to Veeam Cloud Connect ---- no Veeam Backup and Replication server. From the server I'm backing up, I can restore files, folders, volumes, etc --- with no problem. However, I have no option for restore "Applications" via a Veeam Application Explorer (SQL, AD, Exchange)

Any ideas? :) Thanks
Will
---
William Sellers
http://about.me/wsellers
http://twitter.com/
Email: wsellers@gmail.com
Email: william.sellers@eatel.com
Email: wsellers@venyu.com
wsellers
Service Provider
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 22, 2012 4:58 pm
Location: Baton Rouge
Full Name: William Sellers

Re: Restore MSSQL when backing up directly to Cloud Connect

Veeam Logoby Dima P. » Mon Jul 24, 2017 6:40 pm

Hi William,

There is no option to perform application item recovery on agent – you should use Veeam B&R. You can install Veeam B&R, connect in via tenant account you are using on an agent side, rescan the repository (backup files should appear). Then it should be possible to start File level recovery, locate the sql db and double click it to open Veeam Explorer.
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Restore MSSQL when backing up directly to Cloud Connect

Veeam Logoby wsellers » Mon Jul 24, 2017 8:16 pm

Gotcha. So, in the case of Public Cloud ---- Where we aren't doing a Veeam B&R Server installation, I would just recover the MDB/LDB via the Veeam File Explorer --- and attach the database(s)? What about Table-level recovery? Is there a way to leverage the Veeam SQL Explorer through Veeam Accessibility Console, when it releases?
---
William Sellers
http://about.me/wsellers
http://twitter.com/
Email: wsellers@gmail.com
Email: william.sellers@eatel.com
Email: wsellers@venyu.com
wsellers
Service Provider
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 22, 2012 4:58 pm
Location: Baton Rouge
Full Name: William Sellers

Re: Restore MSSQL when backing up directly to Cloud Connect

Veeam Logoby Dima P. » Wed Jul 26, 2017 11:14 pm

I would just recover the MDB/LDB via the Veeam File Explorer --- and attach the database(s)?

Sounds good.
What about Table-level recovery?

Veeam Explorer can help but it goes with VBR.
Is there a way to leverage the Veeam SQL Explorer through Veeam Accessibility Console, when it releases?

I guess no, but lets check with Vitaliy S.
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Restore MSSQL when backing up directly to Cloud Connect

Veeam Logoby Vitaliy S. » Thu Jul 27, 2017 11:19 am

We are planning to add self-restore capabilities down the road for VAC, but it will not be part of the upcoming release, since it is already in a feature lock state.
Vitaliy S.
Veeam Software
 
Posts: 19556
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 14 guests