Comprehensive data protection for all workloads
Post Reply
CurtLeCaptain
Influencer
Posts: 18
Liked: never
Joined: Dec 17, 2014 7:34 pm
Full Name: Curt L
Contact:

Backup Copy and SQL Log Backup

Post by CurtLeCaptain » Oct 22, 2015 5:54 pm

A question about SQL Log backups - we've got backups and SQL log backups going to a standard disk array, then we do a backup copy job that sends the backup to an EMC Data Domain. Does the backup copy job parse the SQL backups as well, or do I need some other mechanism to send those point-in-time recoveries to the Data Domain?

P.Tide
Product Manager
Posts: 5230
Liked: 450 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backup Copy and SQL Log Backup

Post by P.Tide » Oct 22, 2015 6:46 pm

Hi,

No, unfortunatley Backup Copy Job does not send point-in-time recoveries to target, however there is a workaround.

Thank you.

CurtLeCaptain
Influencer
Posts: 18
Liked: never
Joined: Dec 17, 2014 7:34 pm
Full Name: Curt L
Contact:

Re: Backup Copy and SQL Log Backup

Post by CurtLeCaptain » Oct 22, 2015 7:42 pm

Following-up on that, is there a way to target just files of type VLB for the file copy job?

P.Tide
Product Manager
Posts: 5230
Liked: 450 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backup Copy and SQL Log Backup

Post by P.Tide » Oct 23, 2015 10:49 am

is there a way to target just files of type VLB for the file copy job?
Unfortunately, there is no way how you can do that with gui, some powershell scripting might be required. Anyway, including .VLBs only would be impractical because you would not be able to apply those transaction logs to a backup copy restore points.

CurtLeCaptain
Influencer
Posts: 18
Liked: never
Joined: Dec 17, 2014 7:34 pm
Full Name: Curt L
Contact:

Re: Backup Copy and SQL Log Backup

Post by CurtLeCaptain » Oct 23, 2015 1:10 pm

Really. So I have to use file copy (via powershell) to move the entire backup chain to the Data Domain? Am I correct in saying that?

P.Tide
Product Manager
Posts: 5230
Liked: 450 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backup Copy and SQL Log Backup

Post by P.Tide » Oct 23, 2015 1:43 pm

Correct. Actually, you can use any tool of your choice to perform such operation since it's just copying.

CurtLeCaptain
Influencer
Posts: 18
Liked: never
Joined: Dec 17, 2014 7:34 pm
Full Name: Curt L
Contact:

Re: Backup Copy and SQL Log Backup

Post by CurtLeCaptain » Oct 23, 2015 6:22 pm

Final question then as a follow-up. Since it's a copy job, am I really going to see a benefit of the DD at all, I s'pose it would give the benefit of dedupe/compress on the DD side, but I'd lose DD Boost featuresets. Is that a correct statement?

foggy
Veeam Software
Posts: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup Copy and SQL Log Backup

Post by foggy » Oct 26, 2015 8:57 am

Curt, what DD Boost feature sets are you referring to?

CurtLeCaptain
Influencer
Posts: 18
Liked: never
Joined: Dec 17, 2014 7:34 pm
Full Name: Curt L
Contact:

Re: Backup Copy and SQL Log Backup

Post by CurtLeCaptain » Oct 27, 2015 6:47 pm

Where I've got Veeam using a DD Boost repository. Right now we backup to a local SAN, then we backup copy off to the Data Domain. Right now during transforms I see the client-side dedupe of DD Boost happening.

foggy
Veeam Software
Posts: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup Copy and SQL Log Backup

Post by foggy » Oct 28, 2015 11:24 am

Ah, got it. File copy jobs do not utilize DD Boost integration.

Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 13 guests