Host-based backup of Microsoft Hyper-V VMs.
Post Reply
zelgaddiss
Novice
Posts: 3
Liked: never
Joined: Jun 13, 2022 1:58 pm
Full Name: Tyler Gray
Contact:

2 Hyper-V VM environment and DB is 10Gb, anything I can clear out?

Post by zelgaddiss »

Have a Case #05479456, tech advised posting in here as the other commands he sent over did not reduce it with any substance.
With SQL Express there is that pesky 10Gb limit to the database. We have clients with many more VMs and their Veeam SQL databases are a fraction of this one.
Did a query that listed the sizes of tables and there are quite a few more than 1 GB and wondering if I can clear out some old data so we can continue to use SQL express, as the client will not opt for a full SQL license.
Here is the table listing and sizes if anyone knows which I can clean up?
Image
zelgaddiss
Novice
Posts: 3
Liked: never
Joined: Jun 13, 2022 1:58 pm
Full Name: Tyler Gray
Contact:

Re: 2 Hyper-V VM environment and DB is 10Gb, anything I can clear out?

Post by zelgaddiss »

Image

Another shot by number of rows.
johan.h
Veeam Software
Posts: 711
Liked: 178 times
Joined: Jun 05, 2013 9:45 am
Full Name: Johan Huttenga
Contact:

Re: 2 Hyper-V VM environment and DB is 10Gb, anything I can clear out?

Post by johan.h »

Most of the data looks like its taken up by restore points, which looks like it would be important to keep. However, have you tried to determine how long you're keeping session data for and make sure it is as low as reasonably possible?

The other thing you could do is contact support for any advice they might have.
zelgaddiss
Novice
Posts: 3
Liked: never
Joined: Jun 13, 2022 1:58 pm
Full Name: Tyler Gray
Contact:

Re: 2 Hyper-V VM environment and DB is 10Gb, anything I can clear out?

Post by zelgaddiss »

I have set the retention to 7 days but did not make a difference
And I have reached out to support and they directed me here,
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 29 guests