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

[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.]

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]

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.]

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]

Ok - that seemed to have worked. The upgraded was able to complete, the V11 services start, and I see data.

[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.]

Were these all the v10 deployments?

[dcolpitts]

Yes.

[Vitaliy S.]

Ok, thanks! I will ask our dev team to take a look at the provided instructions once again.

[wishr]

Hi Everyone,

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

Thanks