Comprehensive data protection for all workloads
Post Reply
brupnick
Expert
Posts: 196
Liked: 13 times
Joined: Feb 05, 2011 5:09 pm
Full Name: Brian Rupnick
Location: New York, USA
Contact:

More Details Regarding VBR 6.5 Configuration Backup Option

Post by brupnick » Oct 29, 2012 6:07 pm

Good afternoon-

I was wondering if someone could provide some more details as to what exactly is backed up by the built in VBR 6.5 configuration backup utility. I ask because I had created a Powershell script to back up my VBR SQL database and noticed that the file resulting from the 6.5 utility is about 10 times smaller than the file created by my script. My guess is that a backup of the DB includes job history, stats, etc while the 6.5 utility is only backing up the configuration data - job settings, repositories, etc. If someone could clarify this for me, I would greatly appreciate it. In case it helps, here is the command that is being run by my script:

Code: Select all

SQLCMD -S [VBR SERVER NAME]\[VBR INSTANCE NAME]-E -Q "BACKUP DATABASE [VBR DATABASE NAME] TO DISK='\\[FQDN OF TARGET SERVER]\[BACKUP FOLDER NAME]\[VBR DATABASE NAME]_20121028_180017.bak' WITH FORMAT"
Thank you!

habibalby
Expert
Posts: 379
Liked: 24 times
Joined: Jul 18, 2011 9:30 am
Full Name: Hussain Al Sayed
Location: Bahrain
Contact:

Re: More Details Regarding VBR 6.5 Configuration Backup Opti

Post by habibalby » Oct 29, 2012 7:51 pm

hello, do u run this script inside the guest VM or inside a Prescript that will initiate the sql script to Backup SQL? if its a SQL server why don't you run The backup using VSS ?

Vitaliy S.
Product Manager
Posts: 22971
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: More Details Regarding VBR 6.5 Configuration Backup Opti

Post by Vitaliy S. » Oct 29, 2012 8:04 pm

Hi Brian, the list of all exported properties and configuration data is described in our User Guide (page 297), please check it out. Hope this helps!

brupnick
Expert
Posts: 196
Liked: 13 times
Joined: Feb 05, 2011 5:09 pm
Full Name: Brian Rupnick
Location: New York, USA
Contact:

Re: More Details Regarding VBR 6.5 Configuration Backup Opti

Post by brupnick » Oct 29, 2012 8:10 pm

habibalby wrote:hello, do u run this script inside the guest VM or inside a Prescript that will initiate the sql script to Backup SQL? if its a SQL server why don't you run The backup using VSS ?
This is part of a larger Powershell script that I run on my VBR server. I do it this way so that the result is a single file that I can 1.) copy to a server that is backed up to tape and 2.) replicate to my DR site, which is where I would really need this backup. I am starting to do more with replication, so #2 might not be needed in the near future.
Vitaliy S. wrote:Hi Brian, the list of all exported properties and configuration data is described in our User Guide (page 297), please check it out. Hope this helps!
Thanks Vitaliy! I'll definitely check this out.

Post Reply

Who is online

Users browsing this forum: Amit2728, jewij, ned and 28 guests