Transaction Logs in Backup Copy or Replica

Availability for the Always-On Enterprise

Re: Product request: Backup Copy / SQL

Veeam Logoby Mike Resseler » Wed Jun 21, 2017 6:59 am

Hi Mike,
Your request from making sure that a BCJ can do this is noted. You are not the first to ask so consider your vote counted towards the importance of the request ;-)

For your second post: I am sure nobody has ever tested it, and something in my mind tells me it is not going to work. If you do a BCJ then that stored data will be different from the backup data and I doubt that you can import that BCJ backup, together with the chain and VLBs and it will be recognized and usable.
Mike Resseler
Veeam Software
 
Posts: 4273
Liked: 480 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Transaction Logs in Backup Copy or Replica

Veeam Logoby kubimike » Wed Jun 21, 2017 2:04 pm

kubimike
Expert
 
Posts: 306
Liked: 37 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: Transaction Logs in Backup Copy or Replica

Veeam Logoby jameskilbynet » Mon Mar 19, 2018 2:50 pm

This would be a huge win and shouldn't be too difficult to implement
jameskilbynet
Veeam Vanguard
 
Posts: 24
Liked: 4 times
Joined: Wed Jan 14, 2015 11:18 am
Full Name: James Kilby

Re: Transaction Logs in Backup Copy or Replica

Veeam Logoby ian0x0r » Mon Mar 19, 2018 3:09 pm

Yup, please add my voice to this request. I'm surprised that it doesn't do this already.
https://www.snurf.co.uk
ian0x0r
Veeam Vanguard
 
Posts: 215
Liked: 40 times
Joined: Thu Nov 11, 2010 11:53 am
Location: UK
Full Name: Ian Sanderson

Re: Transaction Logs in Backup Copy or Replica

Veeam Logoby FrancWest » Mon May 07, 2018 12:22 am

Too bad this critical feature still isn’t implemented. We ended up installing the Veeam Windows agent inside our SQL server VM. The backup job for this VM runs every hour and also runs a transaction log backup every 15 minutes. We also have a backup copy job that runs every hour. So in case of complete disaster (primary site lost) we loose 1 hour of data, but with a minor disaster we are able to use the transaction log backups if the primary site is still intact. We couldn’t use a regular vm backup job during production hours because the VMware snapshot creation causes a freeze of the Sql server 3 seconds which affects clients using the databases.

Franc.
FrancWest
Enthusiast
 
Posts: 34
Liked: never
Joined: Sun Sep 17, 2017 3:20 am
Full Name: Franc

[MERGED] Best Practice: Transaction Log to Tape

Veeam Logoby yakamoneye18 » Thu May 17, 2018 12:14 pm

Hello everyone,
we are currently switching our MS SQL Databases to transaction logs an backup them with Veeam B&R. We also use tape backups, one daily job (SQL and Fileserver) and one monthly job.
Tape is working great so far, now we want to add the Transaction Log backup files (vlb) into the daily tape job.

- Is this even supported? I already read that copy job backups cannot be used to do point-in-time restore of SQL DBs, because it creates completly new restore points. Since the backup rhythm of SQL backup and SQL tape job is the same, can this work here?
- if it works: what is the best way to achieve this? I tried File-to-Tape job, but i always get errors since the most recent VBL file is still locked by the Transaction Log Copy job.

Thanks!

Tobias
yakamoneye18
Novice
 
Posts: 4
Liked: never
Joined: Thu May 03, 2018 6:20 am
Full Name: Tobias

Re: Best Practice: Transaction Log to Tape

Veeam Logoby PTide » Thu May 17, 2018 2:17 pm

Hi,

- no, not only it is not supported, but also such scenario hasn't been tested. Theoretically it may work if you copy every single vlb and make sure that you apply the appropriate piece of the sequence of vlbs to the chain that you have at hand at the moment of restore.

- have you tried scheduling your File-to-Tape to run a few minutes after the transaction log copy job has finished?

Thanks
PTide
Veeam Software
 
Posts: 4033
Liked: 336 times
Joined: Tue May 19, 2015 1:46 pm

Re: Best Practice: Transaction Log to Tape

Veeam Logoby yakamoneye18 » Fri May 18, 2018 7:37 am

Hi PTide,
thanks for your answer. Changing the Schedule to the point where the transaction log file is closed and the job is finished was one thing i wanted to test. But if i cannot even use these transaction logs with the backups on the tape, i think this is useless.

Are there any plans on the side of Veeam to support moving backups to offline locations together with their transaction log backups? In times of crypto trojans and also with regard to the 3-2-1 model of backups recommended by Veeam, this would be a great feature.
yakamoneye18
Novice
 
Posts: 4
Liked: never
Joined: Thu May 03, 2018 6:20 am
Full Name: Tobias

Re: Best Practice: Transaction Log to Tape

Veeam Logoby foggy » Fri May 18, 2018 4:39 pm

yakamoneye18 wrote:Are there any plans on the side of Veeam to support moving backups to offline locations together with their transaction log backups?

Yes, we do plan to support logs replication within backup copy jobs at least.
foggy
Veeam Software
 
Posts: 16306
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Previous

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: No registered users and 25 guests