Automated Linux restore

[TaylorB]

I've been asked to look into automating a restore of a database on a production linux server to a test server nightly, using the data in the Veeam backup. We are just doing VM snapshot backups, not a Linux agent. (There is a script to freeze DB so it is clean).

So essentially I presume I need a script to mount the latest backup to a server so I can then copy the files to test. Does anyone have any examples or links to the references of where I might begin with this project?

[chris.childerhose]

I would take a look into SureBackup to set that up to do your testing - https://helpcenter.veeam.com/docs/backu ... ml?ver=110

[TaylorB]

Thanks for the reply.

To be clear, this is a development test server I need to put the data on, I am not trying to test my backups. I would like to be able to automate it using the copy I am already collecting with nightly veeam backups

[Mildur]

I would use the data integration API to mount the data to your linux test server.

https://helpcenter.veeam.com/docs/backu ... ml?ver=110

You have an example in the helpcenter:

Code: Select all

$backup = Get-VBRBackup -Name "LinSrv2049"
$restorepoint = Get-VBRRestorePoint -Backup $backup | Sort-Object –Property CreationTime | Select -Last 1
$creds = Get-VBRCredentials -Name "LinAdministrator"
$session = Publish-VBRBackupContent -RestorePoint $restorepoint -TargetServerName 192.0.8.1 -TargetServerCredentials $creds -EnableFUSEProtocol

[Mildur]

Yes, it‘s read only. My example is for mounting it to a linux server. You wanted to „copy files“, so I assumed, read only is good enough.

If you want to change files, a instant vm disk recovery would be better, because you wouldn‘t have to restore the entire virtual disk to just access and edit some files:

https://helpcenter.veeam.com/docs/backu ... ml?ver=110

[TaylorB]

Read only is great, as we just need to copy the files.

Both of those methods look like a good place to start, so thank you for your time.