Separate Jobs for Exchange/SharePoint/OneDrive

[mattbrown80]

I'd like to configure 3 jobs for the organization, 1 job to handle mailboxes, one for SharePoint sites, and one for OneDrive.

I would like these jobs to not require maintenance when new users/sites/drives are added (IE I do not want to have to modify the job to add new users to it after they are created)

It seems the only way I can accomplish the latter is to backup the entire organization in one job, or add the organization and exclude all of the sites (but even this is broken because if they add a new site it won't be excluded)

Is it possible to do what I am looking to do?
Note that I opened a case with Veeam support on this (03240992) and they had no suggestions..

[nielsengelen]

You can add the entire organization and instead of exclude you select which items you want to process on the "select items to backup" tab by going to Edit. This way which you choose 1 of the 4 things you want (or multiple) to backup in the specific job.

Screenshot on how to do it: https://www.dropbox.com/s/98cp7ophbw6cj ... 2.png?dl=0

This way you don't have to worry about new things being added, not being backed up as this way every new onedrive, mailbox, sharepoint site,... will be backed up.

[AlexB82]

Following on from this, is there a way to include all new Teams sites/channels in the job, but exclude all Personal sites? At the moment we have the teams sites checked individually because we don't want to back up the entire organisation's personal sites as well. Obviously there's a risk of a Teams channel being added, but not getting included in the backup unless we check on a regular basis. Thanks !!

[Mike Resseler]

AlexB82,

Not sure if I follow, but team sites don't have personal sites? Personal sites only belong to users.

[AlexB82]

Sorry, maybe I didn't explain it right ... As Teams uses a Sharepoint back-end, so the channels show under the Sites section in VBO. What I need is for all the Teams sites to be automatically added to the backup list, while the Personal sites to be automatically excluded.



Full size pic: https://i.postimg.cc/4yVWwpbP/Teams-VBO.png

[Mike Resseler]

AlexB82,

So in the backend, a team is an office 365 group. Most of the data is being stored indeed in a sharepoint site but it is not located under the personal sites. It is located under the "regular" sites and you should certainly protect it to save the data

Hope it helps
Mike

[AlexB82]

Hi Mike. I already know that. The issue is when someone adds a Teams site in the business, it's not automatically backed up by VBO unless I check the job on a regular basis and manually enable the checkbox by any new created channels. I need this to be automated so we don't need to manually check, and reduce the risk of things not getting backed up. At the same time, I don't want Personal sites to be backed up in this job. It seems at the moment VBO only offers "all or nothing" as automated?

[Mike Resseler]

Ah, now I think I understand it better... Mea Culpa, that's my bad.

So, choose the selection criteria and then add the organization. This will look like you are doing exactly the same as selecting everything but then on the next page of the wizard, in the exclusions, exclude the personal sites of the users (and whatever else you want to exclude). Then you will have everything in your environment but personal sites excluded.

Cheers
Mike

[Mike Resseler]

Actually, I think of another method, but I would need to test this...

If you add entire organization in the selection criteria, I think you can then click on the "Edit" button and exclude personal sites from processing also. But will need to verify to be sure.

[AlexB82]

Hi Mike,
Unfortunately it doesn't appear you get the option to exclude all personal sites automatically either. We can back up the entire org, and exclude personal sites on an individual basis, but again we're in a position where we have to keep editing the job to add exclusions (and as we're a reasonable large organisation with people coming and going, it'd be more work than just including the Teams sites every few days). I think there needs to be more of a differentiation between "Sites" and "Personal Sites" in the software to make this happen (ie have them as their own categories, rather than placing Personal Sites under the main Sites heading)?

[nielsengelen]

As it isn't in the GUI right now, would it help if we (as a workaround) provided a powershell script which you could run via windows task manager?

[AlexB82]

Yeah that'd be awesome if you could

[vipthomps]

Is that powershell script available publicly? I have a similar setup I have going for a client and want the Mailbox + OneDrive in one Job and only Organizational Sites in a second job.

[AlexB82]

I've not received the script myself yet. Hopefully someone is working on it?

[Mike Resseler]

I will ask Niels how far he is (but I believe he is travelling at this point in time...)

[mattbrown80]

Thank you for your response Niel - this works for our requirement.

[nielsengelen]

In regards to the script; due to travel I haven't been able to finish it. I am working on it and hope to have something early next week.

[nielsengelen]

The following script should achieve what is needed. It will get all the SharePoint sites except for the personal sites and add these to an existing job. It will ignore Sites which are already in a job and only get the newly discovered ones.

Just replace your organization name and backup job and it should be good. Please test it before putting this in a Windows task which can run every X minutes.

Code: Select all

Import-Module "C:\Program Files\Veeam\Backup365\Veeam.Archiver.PowerShell\Veeam.Archiver.PowerShell.psd1"

# Get the Organization
$Org = Get-VBOOrganization -Name "yourorganization.onmicrosoft.com"
# Leverage the Job which backs up the required sites
$Job = Get-VBOJob -Name "BACKUPJOBNAME"
# Get all the SharePoint Sites which aren't in a job but exclude the Personal Sites
$Sites = Get-VBOOrganizationSite -Organization $Org -IncludePersonalSite:$false -NotInJob

ForEach ($Site in $Sites) {
  #Write-Progress -Activity "Parsing sites" -status "Site: $Sites.Name" -percentComplete ($i / $Sites.count * 100)
  $newSite = New-VBOBackupItem -Site $Site
  Add-VBOBackupItem -Job $Job -BackupItem $newSite
}

Write-Host "Added a total of " $Sites.count " sites to the job"

[AlexB82]

Script works perfectly - Thanks so much for providing !!

[vipthomps]

Looks great! thanks. I added some logging and scheduled it in task manager

Start-transcript -path C:\<PATH><Filename.LOG> -append
get-date -format g
Write-Host "Added a total of " $Sites.count " sites to the job"
Stop-transcript

[k.klutke]

I ended up finding this thread after Veeam support suggested I post a feature request. I was in the exact same scenario as @AlexB82, I needed to backup all Sites but exclude Personal Sites - Without having to manually maintain(update) the job.

Thank you @vmniels for the PowerShell script, it works perfectly.

Can this thread be renamed to include "Feature Request" so hopefully, one day this because a normal feature?

[nielsengelen]

It is currently already being tracked as a feature request and will be added in a future release.

[jandrewartha]

I currently have a single job that backs up email/archive/onedrive/sites, and due to the time taken to backup onedrive I want to split it into two separate jobs. Is there a way I can do this and not have to download everything again? I'm happy (indeed wanting) to move onedrive to a separate repository.

[nielsengelen]

You can use powershell to move data between repositories via https://helpcenter.veeam.com/docs/vbo36 ... tml?ver=20