Full VeeamBackup.mdf DB due to tape backup

Discussions specific to tape backups

Full VeeamBackup.mdf DB due to tape backup

Veeam Logoby kraeg » Tue Oct 10, 2017 5:53 am

Hello!

We are running a "File to tape backup" of a large physikal fileserver partition with a lot of files. The result is a now a sql express database which is larger than 10 GB.

The largest tables are "dbo.tape.file_version"s and "dbo.tape.file_parts" with over 7GB.

Is there a way to shrink these tables? I can't move to a real MS SQL Server withouth the 10 GB limitation.

I already have limited the history to 200 sessions and 8 days - withouth any effect.

Can anybody help?

Thanks

Axel
kraeg
Lurker
 
Posts: 1
Liked: never
Joined: Sat Sep 30, 2017 7:46 am
Full Name: Axel Kr├Ągelius

Re: Full VeeamBackup.mdf DB due to tape backup

Veeam Logoby v.Eremin » Tue Oct 10, 2017 12:06 pm

I'm afraid, if you plan to continue backing up numerous individual files via files to tape backup, migrating to fully blown SQL server will be the only option available for you. Thanks.
v.Eremin
Veeam Software
 
Posts: 14963
Liked: 1120 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Full VeeamBackup.mdf DB due to tape backup

Veeam Logoby EnerconIT » Wed Oct 11, 2017 5:57 pm

I also have the same situation and the File to Tape backup is only a temporary item. What is the easiest and safest way to clean up the TempDB so we try the backup again? It failed previously and the second time it caused the TempDB to become full.
EnerconIT
Influencer
 
Posts: 13
Liked: never
Joined: Tue Dec 02, 2014 3:21 pm
Full Name: Enercon Engineering

Re: Full VeeamBackup.mdf DB due to tape backup

Veeam Logoby v.Eremin » Thu Oct 12, 2017 2:29 pm

DB modifications must be done under close supervision of our support engineer. So, feel free to open a ticket. Thanks.
v.Eremin
Veeam Software
 
Posts: 14963
Liked: 1120 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Full VeeamBackup.mdf DB due to tape backup

Veeam Logoby EnerconIT » Thu Oct 12, 2017 5:42 pm

What is the limit, if there is one, to the file directory structure that can be copied? If there are a large number of directories and files will that hit a limit that will trigger issues with a file to tape backup?
EnerconIT
Influencer
 
Posts: 13
Liked: never
Joined: Tue Dec 02, 2014 3:21 pm
Full Name: Enercon Engineering

Re: Full VeeamBackup.mdf DB due to tape backup

Veeam Logoby v.Eremin » Fri Oct 13, 2017 11:22 am

The limit is around million of files, but the value might be higher or lower, depending on number of file versions you're preserving. Thanks.
v.Eremin
Veeam Software
 
Posts: 14963
Liked: 1120 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Tape



Who is online

Users browsing this forum: AndrewBk and 12 guests