Scheduled File Restore Test

Availability for the Always-On Enterprise

Scheduled File Restore Test

Veeam Logoby sonic23 » Wed Sep 28, 2016 8:15 pm

Hi,

I just want to know if its possible in Veeam Backup to do an automated/scheduled file/database restore?

Thanks.
sonic23
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Sep 23, 2016 1:31 pm
Full Name: Jesus Martin

Re: Scheduled File Restore Test

Veeam Logoby Shestakov » Thu Sep 29, 2016 9:49 am

Hi Jesus,
You can leverage failover plan to recover VM. Regarding file and database level there is no option to schedule it from UI however you can use a powershell script.
Could you explain your use case by the way?
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Scheduled File Restore Test

Veeam Logoby foggy » Thu Sep 29, 2016 9:49 am

Hi Jesus, could you please describe your requirements in more detail? I believe you can achieve your goals with the help of PowerShell and also would like to pay your attention to SureBackup recoverability testing.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Scheduled File Restore Test

Veeam Logoby sonic23 » Fri Sep 30, 2016 3:49 pm

Hi Shestakov,

Thanks for getting back. We have a couple of requirements in our Business Continuity Plan to test restores every month, that is VM, file, and database restores and I've used surebackups already in the past to test only the VM image. Can you provide me a powershell script to automate a Guest VM file level restore? also if we can do this on database as well.

Thanks.
sonic23
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Sep 23, 2016 1:31 pm
Full Name: Jesus Martin

Re: Scheduled File Restore Test

Veeam Logoby Shestakov » Fri Sep 30, 2016 4:38 pm

Here are some Powershell samples you can use.
I would suggest to keep using Surebackup by the way.
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Scheduled File Restore Test

Veeam Logoby WRS2200 » Sat Oct 01, 2016 5:11 pm

Thank you for this post it was very helpful.
WRS2200
Enthusiast
 
Posts: 28
Liked: 3 times
Joined: Thu Aug 06, 2015 8:21 pm
Full Name: Weston Strom

Re: Scheduled File Restore Test

Veeam Logoby Shestakov » Sat Oct 01, 2016 6:56 pm

You are welcome. Windows task manager can be used to run those scripts on a specific time.
@WRS2200, could you describe your use case? Thanks!
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Scheduled File Restore Test

Veeam Logoby sonic23 » Wed Oct 05, 2016 2:18 pm 1 person likes this post

Hi Nikita,

I was able to make my file and database restore tests using powershell work as you suggested. What I've notice is when invoking restore using powershell I'm not getting any email notifications even if it shows as successful in Veeam console. I have email notification enabled and tested it and works fine, its just not sending notification if launched in powershell. Any idea to resolve this?

Thanks.
sonic23
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Sep 23, 2016 1:31 pm
Full Name: Jesus Martin

Re: Scheduled File Restore Test

Veeam Logoby Shestakov » Wed Oct 05, 2016 2:34 pm

Restore operation doesn`t call email notification since it`s not a job.
However you can either create Veeam ONE alarm if you use it or use Send-MailMessage cmdlet.
Thanks!
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Scheduled File Restore Test

Veeam Logoby sonic23 » Wed Oct 05, 2016 2:46 pm

we have VeeamOne, trying it now but the "New" button is greyed out.
sonic23
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Sep 23, 2016 1:31 pm
Full Name: Jesus Martin

Re: Scheduled File Restore Test

Veeam Logoby sonic23 » Wed Oct 05, 2016 3:09 pm

Nevermind..I got it :) Thanks..
sonic23
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Sep 23, 2016 1:31 pm
Full Name: Jesus Martin

Re: Scheduled File Restore Test

Veeam Logoby Shestakov » Wed Oct 05, 2016 3:28 pm

You needed to choose category in the alalrm tree on the left for the alarm creation. Glad you`ve found it.
If you have questions about the alarm creation, feel free asking.
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Scheduled File Restore Test

Veeam Logoby sonic23 » Wed Oct 05, 2016 3:51 pm

Lol..I'm back :) I checked this document from Veeam to know the Event trigger for restore but cant find anything.

https://helpcenter.veeam.com/one/alarms ... vents.html
sonic23
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Sep 23, 2016 1:31 pm
Full Name: Jesus Martin

Re: Scheduled File Restore Test

Veeam Logoby Shestakov » Wed Oct 05, 2016 4:06 pm

There is no such a predefined alarm in the current version, but you can easily create it manually. As an alarm rule you can use these events:
210 Restore session started
250 Restore vSphere task finished
251 Restore Hyper-V task finished
290 Restore session finished
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Scheduled File Restore Test

Veeam Logoby sonic23 » Wed Oct 05, 2016 4:28 pm

Tried it but didn't work..do I need to include the numbers as well? I defined it under "Backup & Replication" folder, and created the alarm on the "Backup Server". Is this correct? From the Alarm Settings, under "Rules" tab, I put "Rule Type" to be "Event", and the "Event Name" is "Restore session finished". I've assigned to the whole backup infrastructure and set the "Action" to "Send email notification" with my email on it. I ran my powershell FLR script, which is successful but I didnt get a notification.
sonic23
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Sep 23, 2016 1:31 pm
Full Name: Jesus Martin

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google Feedfetcher, Yahoo [Bot] and 13 guests