Monitoring and reporting for Veeam Data Platform
Post Reply
dcolpitts
Veeam ProPartner
Posts: 119
Liked: 24 times
Joined: Apr 01, 2011 10:36 am
Full Name: Dean Colpitts
Location: Atlantic coast of Canada
Contact:

How to purge/shrink the V10 DB prior to V11 upgrade?

Post by dcolpitts »

I've got a couple of customer locations where the upgrade to V11 is failing because the SQLDB has hit 10Gb in SQL Express. Of course this kills the upgrade, and results in having to revert the snapshot on the VeeamOne VM. Maybe I'm doing something wrong, but kb2357 seems to fail because those tables do not exist.

Code: Select all

Msg 4701, Level 16, State 1, Line 1
Cannot find the object "PerfSampleLow12" because it does not exist or you do not have permissions.
Therefore, what's the appropriate way to purge/shrink the V10 DB? I'd rather not drop the DB and start fresh if I don't have to.

dcc
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by Vitaliy S. »

Hi Dean,

Have you tried executing it without that table? If you don't have PerfSampleLow12 data, then it is either hasn't been collected yet or there are no permissions to delete it. If this still does not help, then our support team would be able to assist you with the upgrade.

Thanks!
dcolpitts
Veeam ProPartner
Posts: 119
Liked: 24 times
Joined: Apr 01, 2011 10:36 am
Full Name: Dean Colpitts
Location: Atlantic coast of Canada
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by dcolpitts »

Yeah - I don't have any of those tables listed in kb2357. I do have PerfSampleLow, which was 3995MB, so I took a leap of faith and truncated it. It literally just finished, so I'll try the upgrade again in a few minutes. The next two largest tables were PerfSampleMed (1212MB) and Event (1111MB). I didn't touch these two.

dcc
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by Vitaliy S. »

Hmm.... Let me ask our RnD team to review the KB once again and provide scripts for cases like yours. Dean, could you please follow up on how everything goes (in this topic) so I could share this knowledge with our support and dev teams?
dcolpitts
Veeam ProPartner
Posts: 119
Liked: 24 times
Joined: Apr 01, 2011 10:36 am
Full Name: Dean Colpitts
Location: Atlantic coast of Canada
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by dcolpitts »

Ok - that seemed to have worked. The upgraded was able to complete, the V11 services start, and I see data.
dcolpitts
Veeam ProPartner
Posts: 119
Liked: 24 times
Joined: Apr 01, 2011 10:36 am
Full Name: Dean Colpitts
Location: Atlantic coast of Canada
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by dcolpitts »

Vitaliy - I should point out to, I've looked a few different customer sites, all V10, and none of them have those tables listed in KB2357. But PerfSampleLow and PerfSampleMed definitely exist in all of them.
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by Vitaliy S. »

Were these all the v10 deployments?
dcolpitts
Veeam ProPartner
Posts: 119
Liked: 24 times
Joined: Apr 01, 2011 10:36 am
Full Name: Dean Colpitts
Location: Atlantic coast of Canada
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by dcolpitts »

Yes.
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by Vitaliy S. »

Ok, thanks! I will ask our dev team to take a look at the provided instructions once again.
wishr
Veteran
Posts: 3077
Liked: 455 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: How to purge/shrink the V10 DB prior to V11 upgrade?

Post by wishr » 1 person likes this post

Hi Everyone,

Quick update: we've uploaded a new version of the script to the KB2357.

Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests