Host-based backup of VMware vSphere VMs.
Post Reply
nunciate
Expert
Posts: 247
Liked: 39 times
Joined: May 21, 2013 9:08 pm
Full Name: Alan Wells
Contact:

Export Job Settings from SQl

Post by nunciate »

Any SQL experts out there know a query that I can run to view all of my job settings for each job type? Need to quickly review all settings on Bakcup, Backup Copy, Tape and Replications jobs.
I want to see everything including the info on the Advanced tabs that shows what days synthetic fulls run on and all that.

I wish you could add columns to the job display in the console so I could easily verify when all of my full backups occur on the weekend and adjust as needed. Right now I have to edit every job manually and go through all the tabs.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Export Job Settings from SQl

Post by Vitaliy S. »

Hi Alan,

I'm not sure about SQL Server, but it should be possible to do via PowerShell > Export Job Configuration

Thanks!
veremin
Product Manager
Posts: 20271
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Export Job Settings from SQl

Post by veremin »

Information regarding synthetic full backup can be gotten via the following one-liner:

Code: Select all

Get-VBRJob | select name, {$_.options.BackupTargetOptions.TransformFullToSyntethic}, {$_.options.BackupTargetOptions.TransformToSyntethicDays}
Thanks.
Post Reply

Who is online

Users browsing this forum: IvanK and 68 guests