Part 2 - Agent Based Backup SQL Always On 2022 Using Veeam

How to Enable SSH and Secure Copy (SCP) on Linux?

 Execute this command:

sudo apt update

sudo apt install openssh-server

nano /etc/ssh/sshd_config

Inside the file, locate the "PermitRootLogin" and set to "yes"

save the file

Restart the SSH server

systemctl restart ssh

Change Veeam Backup Job Setting with PowerShell | Maintain Same Job Name

There is no rename PowerShell cmdlet on veeam v12. So here is my workaround to maintain the same backup job. If I use the clone backup job name, it will perform an active full when scheduling the job run. This is a norm scenario as the backup job name has changed and existing backup data cannot map.

# Connect to the Veeam Backup & Replication server

Connect-VBRServer -Server "VBR12GA"

# Get the backup job you want to clone

$sourceJob = Get-VBRJob -Name "VmwareVM-DC01-demodomain"

# Get the new proxy server

$newProxy1 = Get-VBRViProxy -Name "proxy1.veeamlab.local"

$newProxy2 = Get-VBRViProxy -Name "proxy2.veeamlab.local"

#update proxy

Set-VBRJobProxy -Job $sourceJob -Proxy $newProxy1, $newProxy2

# Specify the name for the cloned job

$clonedJobName = "ClonedJobName-Lai"

$clonedJobNameOriginal = "VmwareVM-DC01-demodomain"

# Clone the backup job

$clonedJob1 = Copy-VBRJob -Job $sourceJob -Name $clonedJobName -Repository "Default Backup Repository"

Remove-VBRJob -Job $sourceJob -Confirm:$false

$clonedJob2 = Copy-VBRJob -Job $clonedJob1 -Name $clonedJobNameOriginal

Remove-VBRJob -Job $clonedJob1 -Confirm:$false

# Save the cloned job

Set-VBRJobOptions -Job $clonedJob2

# Disconnect from the Veeam Backup & Replication server

Disconnect-VBRServer

Change Veeam Backup Job Setting Using Powershell

 Below script is using Veeam v12.

I would like to change the existing backup job in terms of proxy and backup repository. In veeam v12, changing the backup repository on the backup job is not supported. 

Therefore here is my workaround:

# Connect to the Veeam Backup & Replication server
Connect-VBRServer -Server "VBRServerName" 

# Get the backup job you want to clone
$sourceJob = Get-VBRJob -Name "OldJobName" 

# Get the new proxy server
$newProxy1 = Get-VBRViProxy -Name "newproxy1"
$newProxy2 = Get-VBRViProxy -Name "newproxy2"

 #update proxy

Set-VBRJobProxy -Job $sourceJob -Proxy $newProxy1, $newProxy2

 # Specify the name for the cloned job

$clonedJobName = "ClonedJobName"

 # Clone the backup job

$clonedJob = Copy-VBRJob -Job $sourceJob -Name $clonedJobName -Repository "NewRepository"

# Save the cloned job

Set-VBRJobOptions -Job $clonedJob

# Disconnect from the Veeam Backup & Replication server

Disconnect-VBRServer

In summary,

• Change new proxy
• Clone a new job
• Change new repository name

Part1-Agentless Backup SQL AlwaysOn 2022 Using Veeam | Tip and Tricks