Files to Tape Job, change order files are backed up?

Everything about backing up to tape

Files to Tape Job, change order files are backed up?

Veeam Logoby ccatlett1984 » Mon Mar 14, 2016 2:19 pm

I have a files to tape job, I'd like to change the order files are written to tape.
After it pulls the directory listing, i'd like to have it write from oldest to newest.

This job is backing up SQL transaction logs to tape, and sometimes fails to backup a file that is still being written to.
If the order went from oldest file to newest, those errors would not occur.

Can this be changed?
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

Re: Files to Tape Job, change order files are backed up?

Veeam Logoby PTide » Mon Mar 14, 2016 3:08 pm

Hi,

May I ask you why do you prefer to use File to Tape job to copy transaction log? Have you considered to use SQL Logs backup feature?

If the order went from oldest file to newest, those errors would not occur.
As far as I know SQL server always writes to a log file so it does not matter if you sort them by date or not - the very last log file will be locked due to an SQL server writing to it.

Thank you.
PTide
Veeam Software
 
Posts: 3022
Liked: 247 times
Joined: Tue May 19, 2015 1:46 pm

Re: Files to Tape Job, change order files are backed up?

Veeam Logoby ccatlett1984 » Fri Mar 18, 2016 7:22 pm

correct the last log is locked, so I see a failure for my tape job, since it can't process some of the files.

due to the way we protect our sql databases, the trans log feature would not work for us.
We replicate our data to a 2nd site, and it goes to tape there. Since there is not a "copy trans logs" function, we can't use the feature.
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

Re: Files to Tape Job, change order files are backed up?

Veeam Logoby PTide » Mon Mar 21, 2016 9:41 am

Currently there is no way to do that. The only dirty hack I could suggest you would be to schedule a pre-job script that copies all log files except the very last to some separate directory so your File To Tape job grabs stuff from that directory. Also could you please describe the way you protect your database, maybe there are other ways?

Thank you.
PTide
Veeam Software
 
Posts: 3022
Liked: 247 times
Joined: Tue May 19, 2015 1:46 pm

Re: Files to Tape Job, change order files are backed up?

Veeam Logoby ccatlett1984 » Mon Mar 21, 2016 4:01 pm

moving 500gb+ of files every day, to "fix" this, is not an option.
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

Re: Files to Tape Job, change order files are backed up?

Veeam Logoby PTide » Mon Mar 21, 2016 4:11 pm

moving 500gb+ of files every day, to "fix" this, is not an option.
I agree with you. You've mentioned that there is some backup routine design reason behind not using Log Backup, may I ask you about the details?

Thank you.
PTide
Veeam Software
 
Posts: 3022
Liked: 247 times
Joined: Tue May 19, 2015 1:46 pm

Re: Files to Tape Job, change order files are backed up?

Veeam Logoby ccatlett1984 » Mon Mar 28, 2016 1:31 pm

We replicate our data to a 2nd site, and it goes to tape there. Since there is not a "copy trans logs" function, we can't use the feature.
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

Re: Files to Tape Job, change order files are backed up?

Veeam Logoby Dima P. » Fri Apr 08, 2016 5:12 pm

Chris,

Thanks, the functionality to set the priority for source files is definitely in the list of next version’s improvements.
Dima P.
Veeam Software
 
Posts: 6263
Liked: 441 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov


Return to Tape



Who is online

Users browsing this forum: No registered users and 6 guests