Is it possible to export database permissions?

[lorimer]

We currently have ESX 3.5 deployed across 32 blades with ~250 virtual machines running. Our database mushroomed in size last year to being well over 100G. This is causing issues on the SQL server now. According to the sizing tools we can find, our database should be a fraction of that size. We tried running a cleanup script, but after several hours (5 or 6), it appeared to hang. We are to the point now where we would like to start with a new database. We know we will lose historical performance and task information. That is fine. What we would like to keep though is the permissions and folder structure for all of the virtual machines. Is there a way to export just that data to a new database?

[lorimer]

bump.

[SuryaVMware]

What kind of cleanup are we talking about here?

What is the current recovery model for the DB? is it Full or Simple?

Did you try truncate/Dump the logs?

-Surya

[kjb007]

Unless you also keep the associations between virtual center object ID's, the permissions probably will not mean much. Check your table sizes and see what the largest tables are. If they're the stats tables, then you should be able to truncate those instead of creating a new database itself.

What you can also do is to go to the admin section in vi client, and if you click on the roles in the roles tab, the right hand side will show you every place that row is set, and what object that role applies to. It's very manual, but at least you have a way to recreate the exact permission set that you have.

-KjB