Maintain control of your Microsoft 365 data
Post Reply
mattbrown80
Service Provider
Posts: 56
Liked: 13 times
Joined: Nov 26, 2014 9:34 pm
Full Name: Matt Brown
Contact:

Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
AlexB82
Enthusiast
Posts: 56
Liked: 8 times
Joined: May 01, 2018 2:06 pm
Full Name: Alex
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by Mike Resseler »

AlexB82,

Not sure if I follow, but team sites don't have personal sites? Personal sites only belong to users.
AlexB82
Enthusiast
Posts: 56
Liked: 8 times
Joined: May 01, 2018 2:06 pm
Full Name: Alex
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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.

Image

Full size pic: https://i.postimg.cc/4yVWwpbP/Teams-VBO.png
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Enthusiast
Posts: 56
Liked: 8 times
Joined: May 01, 2018 2:06 pm
Full Name: Alex
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Enthusiast
Posts: 56
Liked: 8 times
Joined: May 01, 2018 2:06 pm
Full Name: Alex
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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?
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
AlexB82
Enthusiast
Posts: 56
Liked: 8 times
Joined: May 01, 2018 2:06 pm
Full Name: Alex
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by AlexB82 »

Yeah that'd be awesome if you could :)
vipthomps
Service Provider
Posts: 60
Liked: 6 times
Joined: Dec 06, 2010 7:51 pm
Full Name: Eric Thompson
Location: Boston, MA
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Enthusiast
Posts: 56
Liked: 8 times
Joined: May 01, 2018 2:06 pm
Full Name: Alex
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by AlexB82 »

I've not received the script myself yet. Hopefully someone is working on it?
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by Mike Resseler »

I will ask Niels how far he is (but I believe he is travelling at this point in time...)
mattbrown80
Service Provider
Posts: 56
Liked: 13 times
Joined: Nov 26, 2014 9:34 pm
Full Name: Matt Brown
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by mattbrown80 »

Thank you for your response Niel - this works for our requirement.
nielsengelen
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
nielsengelen
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by nielsengelen » 2 people like this post

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"
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
AlexB82
Enthusiast
Posts: 56
Liked: 8 times
Joined: May 01, 2018 2:06 pm
Full Name: Alex
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by AlexB82 »

Script works perfectly - Thanks so much for providing !!
vipthomps
Service Provider
Posts: 60
Liked: 6 times
Joined: Dec 06, 2010 7:51 pm
Full Name: Eric Thompson
Location: Boston, MA
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by vipthomps » 2 people like this post

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
Influencer
Posts: 11
Liked: 3 times
Joined: Nov 23, 2018 1:52 am
Full Name: Kris Klutke
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by nielsengelen » 1 person likes this post

It is currently already being tracked as a feature request and will be added in a future release.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
jandrewartha
Enthusiast
Posts: 30
Liked: 3 times
Joined: Feb 13, 2017 1:49 am
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by 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
Product Manager
Posts: 5619
Liked: 1177 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Separate Jobs for Exchange/SharePoint/OneDrive

Post by nielsengelen »

You can use powershell to move data between repositories via https://helpcenter.veeam.com/docs/vbo36 ... tml?ver=20
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
Post Reply

Who is online

Users browsing this forum: No registered users and 17 guests