Files 2 Tape SQLServer Maintenance

Discussions specific to tape backups

Files 2 Tape SQLServer Maintenance

Veeam Logoby Reklov » Wed 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
Reklov
Enthusiast
 
Posts: 53
Liked: 1 time
Joined: Thu Aug 28, 2014 12:16 pm

Re: Files 2 Tape SQLServer Maintenance

Veeam Logoby v.Eremin » Wed 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.
v.Eremin
Veeam Software
 
Posts: 14966
Liked: 1122 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Files 2 Tape SQLServer Maintenance

Veeam Logoby Reklov » Wed Jul 25, 2018 1:15 pm

The Ticketnumber is

Case # 03114289

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

Re: Files 2 Tape SQLServer Maintenance

Veeam Logoby v.Eremin » Wed 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.
v.Eremin
Veeam Software
 
Posts: 14966
Liked: 1122 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Files 2 Tape SQLServer Maintenance

Veeam Logoby Reklov » Thu 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
Reklov
Enthusiast
 
Posts: 53
Liked: 1 time
Joined: Thu Aug 28, 2014 12:16 pm

Re: Files 2 Tape SQLServer Maintenance

Veeam Logoby v.Eremin » Thu 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.
v.Eremin
Veeam Software
 
Posts: 14966
Liked: 1122 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Files 2 Tape SQLServer Maintenance

Veeam Logoby Reklov » Fri Jul 27, 2018 7:07 am

... Vladimir, thanks !
Reklov
Enthusiast
 
Posts: 53
Liked: 1 time
Joined: Thu Aug 28, 2014 12:16 pm


Return to Tape



Who is online

Users browsing this forum: No registered users and 9 guests