Discussions specific to tape backups
Post Reply
kraeg
Lurker
Posts: 1
Liked: never
Joined: Sep 30, 2017 7:46 am
Full Name: Axel Krägelius
Contact:

Full VeeamBackup.mdf DB due to tape backup

Post by kraeg » 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

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

Re: Full VeeamBackup.mdf DB due to tape backup

Post by v.Eremin » 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.

EnerconIT
Influencer
Posts: 13
Liked: never
Joined: Dec 02, 2014 3:21 pm
Full Name: Enercon Engineering
Contact:

Re: Full VeeamBackup.mdf DB due to tape backup

Post by EnerconIT » 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.

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

Re: Full VeeamBackup.mdf DB due to tape backup

Post by v.Eremin » 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.

EnerconIT
Influencer
Posts: 13
Liked: never
Joined: Dec 02, 2014 3:21 pm
Full Name: Enercon Engineering
Contact:

Re: Full VeeamBackup.mdf DB due to tape backup

Post by EnerconIT » 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?

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

Re: Full VeeamBackup.mdf DB due to tape backup

Post by v.Eremin » 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.

Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests