Discussions specific to tape backups
Post Reply
ICarter
Novice
Posts: 9
Liked: never
Joined: Apr 15, 2013 3:37 pm
Full Name: Ian Carter
Contact:

Tape backup of SQL transaction logs (VLB)

Post by ICarter » Jan 27, 2015 8:16 am

We've recently started evaluating backing up our SQL transactions logs using Veeam which creates VLB files. I notice from the documentation (and our experience) that VLB files are excluded from tape backup. Is it likely that in the future they will be included? It's great we can recover down to a 15 minute granuality when the data is in the repository, but it would be equally nice to be able to do this when pulling an older archive back off tape rather than dropping back to the full/incremental recovery point. It would also be nice to have a copy of the log backups on tape from a DR point of view.

Cheers, Ian

veremin
Product Manager
Posts: 16554
Liked: 1379 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by veremin » Jan 27, 2015 9:24 am

For now you can probably stick to file to copy job and archive to tape mediums log backups along with backups they depend on. Thanks.

vDuck
Veeam Software
Posts: 56
Liked: 3 times
Joined: Apr 02, 2018 4:16 am
Full Name: Satoko Takahashi
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by vDuck » Feb 04, 2019 9:28 am

How about Update4?

Thx.

Dima P.
Product Manager
Posts: 10148
Liked: 817 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Dima P. » Feb 04, 2019 9:52 am

Approach remains the same. There is no transaction log backup within backup to tape jobs but you can process those with separate file to tape jobs.

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Mar 06, 2019 2:36 pm

If we use backup to tape for backup files and file to tape for VLBs, can those files be reconnected if restored backup to disk?

Dima P.
Product Manager
Posts: 10148
Liked: 817 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Dima P. » Mar 09, 2019 10:45 pm

Regnor,

Yes, you need to restore all backup files from tape and then application item recovery will work.

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Mar 12, 2019 8:20 am

Hi Dima,

thanks.
What happens if we lose a VLB or the meta file?

Dima P.
Product Manager
Posts: 10148
Liked: 817 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Dima P. » Mar 12, 2019 11:20 am

VLB is required for application item recovery, so image level backup remains operational. Metadata file is required for image based backup, so it's loss may affect further recovery from both image based backup and transaction log backup.

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Mar 12, 2019 11:44 am

I'm only thinking about the application item recovery (transaction level).
I've just posted it in the other topic, we want to ensure that the log backups are on two different media. So for now we do backup to tape + file to tape for the VLB and VSM.
The question is a) if we restore both back to disk, will a transaction based restore be available, and b) if we lose a file in the VLB chain or the entire VSM, will the complete chain be broken or is a partitial log restore still possible?

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Mar 27, 2019 9:19 am

Hi Dima, can you provide me any additional information on the transaction log backup?

Dima P.
Product Manager
Posts: 10148
Liked: 817 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Dima P. » Mar 28, 2019 10:50 am

Hello Regnor,

I double checked the way how transaction logs are linked to the image based backup and, unfortunately, backup to tape for image backup + file to tape for log backup wont help: after vm backup file is restored from tape it wont have all required metadata to link vlb correctly. Looks like we have two options now:

1. Use file to tape for both imaged based backup and transaction log backup. In such case metadata will be stored in the original format with all the links kept. Such approach wont work in you are performing backup in forever incremental backup mode (so keep in mind that periodic full is required is such case).

2. Native sql backup to disk, then take vm backup and then write such vm to tape would be another option.

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Apr 08, 2019 7:30 am

Hi Dima,

thanks for your replay.
I hope this will be enhanced in the next updates (see the backup copy topic).

Would it help if we include the VBM to the file to tape job?
So later we restore the VBK/VIB from backup to tape, restore the VLB,VBM and VSM to the same folder and Veeam magically matches everything together?

Dima P.
Product Manager
Posts: 10148
Liked: 817 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Dima P. » Apr 09, 2019 6:47 pm

Unfortunately that's not going to work, restored backup file will 'understand' only it's original vbm file from tape. I've already added your vote to this feature request, thank you!

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Apr 10, 2019 3:06 pm

Thank you Dima for making that clear.
There are some customers which would require additional copies of the transaction logs, so let's see if this will be implemented in the future.

Dima P.
Product Manager
Posts: 10148
Liked: 817 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Dima P. » Apr 12, 2019 7:38 pm

You are welcome. I'll keep the reference to this thread and add you vote to the feature request. Cheers!

fga
Novice
Posts: 3
Liked: never
Joined: Feb 04, 2019 10:08 pm
Location: Germany
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by fga » Apr 20, 2019 10:52 pm

Count me in as well.
GFS to tape jobs with linked backup jobs in them should include everything that is needed to restore anything that is inside of such a backup job.
For me this also includes SQL transaction logs.

stewsie
Expert
Posts: 106
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by stewsie » Jun 14, 2019 7:32 am

Can someone confirm that transaction logs are not copied in Copy jobs or backed up in Tape backups? If this is correct then this is a major issue

Thanks

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Jun 16, 2019 2:13 pm

That's true. The transaction logs won't be included in copy or tape jobs.

stewsie
Expert
Posts: 106
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by stewsie » Jun 17, 2019 7:03 am

As the TL backup files will not be part of a copy or tape job can anyone advise how to take a second copy of these? The backup repository in use is a scale out repository so doing a file copy may not be possible and after reading some of the replies above the files may be useless anyway.

Thanks

veremin
Product Manager
Posts: 16554
Liked: 1379 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by veremin » Jun 17, 2019 5:46 pm 1 person likes this post

For now you can use files to tape backup for both image-level and tlog backups. Also, we're aware of this feature request and already working on it. Thanks!

Regnor
Service Provider
Posts: 310
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Regnor » Jun 18, 2019 9:27 am

The "and" is important here; you need to use file-to-tape for both VM and log backups.

stewsie
Expert
Posts: 106
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by stewsie » Jun 18, 2019 9:31 am

I am running a file to tape backup that hopefully includes the VM and TL backup files

Thanks

stewsie
Expert
Posts: 106
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by stewsie » Jun 18, 2019 11:02 am

If I want to restore using the file to tape backup do I need to restore all files to disk and then import into Veeam and then restore from disk? The restore process is different to the backup restore process especially for specifying a restore point.

veremin
Product Manager
Posts: 16554
Liked: 1379 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by veremin » Jun 18, 2019 5:33 pm

- Restore needed files to disk (full; or full plus increments, if you're planing to restore from incremental restore point)
- Import them to backup console
- Restore data

stewsie
Expert
Posts: 106
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by stewsie » Jun 19, 2019 6:53 am

OK thanks. Will have to review how we will backup these servers now. Probably just let the DBA backup using native SQL tools.

Dima P.
Product Manager
Posts: 10148
Liked: 817 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by Dima P. » Jun 19, 2019 4:42 pm

Paul,
Probably just let the DBA backup using native SQL tools.
So far it looks like the best option when you need to store log backups on tape. Cheers!

stewsie
Expert
Posts: 106
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Tape backup of SQL transaction logs (VLB)

Post by stewsie » Jun 20, 2019 8:36 am

I have had direct contact from the customer care manager who has been very helpful.

Thanks for the input

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests