VMware Cloud Community
Jae_Ellers
Virtuoso
Virtuoso
Jump to solution

Can I recover deleted performance data

Had my VC down yesterday due to a database inconsistency. The VMware tech had me delete the performance data. After they blamed the outage on non-existant network condition and stopped helping me, I discovered the problem and fixed the issue. It had nothing to do with old perf data.

The only problem is that now things are up and working fine I have no historical perf data. And several new VMs have been created since VC came back up.

Can I recover the old stats & hist tables and import them? Should I restore the old db (how will the new vms be dealt with)? Should I just live with no historical data?

What to do?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=- http://blog.mr-vm.com http://www.vmprofessional.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reply
0 Kudos
1 Solution

Accepted Solutions
admin
Immortal
Immortal
Jump to solution

I'd live without the performance data personally.

You could try a restore, remove the new VM's from the inventory, do a VC DB restore, then re-register the VMs you removed.

View solution in original post

Reply
0 Kudos
3 Replies
admin
Immortal
Immortal
Jump to solution

I'd live without the performance data personally.

You could try a restore, remove the new VM's from the inventory, do a VC DB restore, then re-register the VMs you removed.

Reply
0 Kudos
esiebert7625
Immortal
Immortal
Jump to solution

The only way I know of would be to restore the SQL database. You can only export the performance data through the VI client not import it. This is probably going to be more work then it's worth. The data you want to restore is in the VPX_HIST_STAT table.

Here's some documentation I did on the database...

http://www.vmware.com/community/thread.jspa?messageID=626899&#626899

SQL restore links...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

http://articles.techrepublic.com.com/5100-1035_11-1041267.html

Jae_Ellers
Virtuoso
Virtuoso
Jump to solution

Thanks guys. I was wondering about restoring the old backup to a different db, export the tables and them importing them into the current db. I think I'll just live with it as a reminder to check those maintenance plans more carefully.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=- http://blog.mr-vm.com http://www.vmprofessional.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reply
0 Kudos