Discussions specific to tape backups
Post Reply
Reklov
Enthusiast
Posts: 53
Liked: 1 time
Joined: Aug 28, 2014 12:16 pm
Contact:

Files 2 Tape SQLServer Maintenance

Post by Reklov » Jul 25, 2018 12:30 pm

Hi,

I'm using VBR 9.5 with SQLExpress 2008R2.
I like to create a "Files to Tape" Job. Veeam Support told me, that this will create a lot of entries in the Veeam Database. To evoid reaching the 10 GB Sizeboarder, I like to do some Maintenance ( eg purge all records older than 2 Weeks ), but the Express Edition have no possibility to create some maintenance Jobs. Alternativly I can use a scheduled SQL Script.
Veeam Support told me, that the affected Tables are

dbo.Tape.file_versions
dbo.Tape.files

Has somebody done something similary and can give me the Code ?

BTW, it would not be great to Backup "Backups to Tape" as well "Files to Tape" within one Job with the same Tape(s) ?

Thanks !
Regards
Volker

v.Eremin
Veeam Software
Posts: 15157
Liked: 1141 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Files 2 Tape SQLServer Maintenance

Post by v.Eremin » Jul 25, 2018 1:05 pm

I think purging mentioned tables might lead might to undesired consequences, as based on the names they contain information about files archived to tapes along with versions of those files.

Can you tell us the support ticket Id, so that we can take a look?

Thanks.

Reklov
Enthusiast
Posts: 53
Liked: 1 time
Joined: Aug 28, 2014 12:16 pm
Contact:

Re: Files 2 Tape SQLServer Maintenance

Post by Reklov » Jul 25, 2018 1:15 pm

The Ticketnumber is

Case # 03114289

Thanks !

v.Eremin
Veeam Software
Posts: 15157
Liked: 1141 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Files 2 Tape SQLServer Maintenance

Post by v.Eremin » Jul 25, 2018 3:03 pm

Got it, by manually purging the said tables you might leave the configuration db in corrupted state, and support team won't be able to help you, since custom db modifications are considered unsupported.

So, you can:

- Either ask support team to assist you with this process
- Or mark unused tapes (or tapes that you don't need to keep any longer) as free and let jobs re-use them during next cycles. Basically this will be a supported analogue of purging the db tables

But before doing that I'd probably test file to tapes jobs and see whether the db grows to the level where one of two mentioned options is needed.

Thanks.

Reklov
Enthusiast
Posts: 53
Liked: 1 time
Joined: Aug 28, 2014 12:16 pm
Contact:

Re: Files 2 Tape SQLServer Maintenance

Post by Reklov » Jul 26, 2018 6:35 am

Hi,

this sounds good. If a Tape marked as free, this will purge the belonging records, right ? I'll have a look to script this with Powershell and before this I have scheduled a File2Tape Job for the comming WE. I'll see what happen.
If I need the content by a as free marked Tape, I can do a "Catalog Tape", right ?

What about the possibility to have "Backups2Tape" as well as "Files2Tape" within one Job ?

Regards
Volker

v.Eremin
Veeam Software
Posts: 15157
Liked: 1141 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Files 2 Tape SQLServer Maintenance

Post by v.Eremin » Jul 26, 2018 11:34 am

this sounds good. If a Tape marked as free, this will purge the belonging records, right
Correct.
If I need the content by a as free marked Tape, I can do a "Catalog Tape", right ?
Correct.
What about the possibility to have "Backups2Tape" as well as "Files2Tape" within one Job ?
It's not possible to combine those activities within one job.

Anyway, if I were you, I would test file to tape jobs first to see whether the db size becomes an issue.

Thanks.

Reklov
Enthusiast
Posts: 53
Liked: 1 time
Joined: Aug 28, 2014 12:16 pm
Contact:

Re: Files 2 Tape SQLServer Maintenance

Post by Reklov » Jul 27, 2018 7:07 am

... Vladimir, thanks !

Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests