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?
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.
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.
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򙃓
SQL restore links...
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
http://articles.techrepublic.com.com/5100-1035_11-1041267.html
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.