Link to home
Start Free TrialLog in
Avatar of elaw
elaw

asked on

If I reinstall the virtual center server and create a new database what inofomration will be lost from the old database

Due to the few power shutdown, the SQL installation and the database of the virtual centre is corrupted.  I would like to install again and it is giving two options 1. to use the existing database or 2. Create a new database with SQL MSDE.  I would like to find out if take the 2nd option, what information i would need from the old database.
ASKER CERTIFIED SOLUTION
Avatar of Paul Solovyovsky
Paul Solovyovsky
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of elaw
elaw

ASKER

So is there a work around so that we dont loose the resourse pool information, roles/permissions.
Avatar of elaw

ASKER

Please let me know if the root permissions will be dropped as well and we have to redefine.  or Atleast the root permissions will be there and we could use its existing password.
When you re-install VC you'll have to add all the hosts back in.  Since access to VC is based per local adminstrators by default then you should have access to VC once you re-install as long as you have local admin access on the machine itself.
The only workaround not to lose the information is to use the same database, since it keeps all the settings at least from my experience.
Avatar of elaw

ASKER

Is it difficult to redefine the all the resource pool settings etc.  I m using 2.5 version
Avatar of elaw

ASKER

if I want to create a SQL database for this purpose then what will be the table and fileld structure.  Sorry i m using 2.02 version for the ESX servers.
What version of VirtualCenter are you using ?
Avatar of elaw

ASKER

paulsolov - Since you have performed the same operation, could you please send me the steps you taken to reconfigure the VMWare configuraiton.
... probably all user info will be lost
...do you have good full backup of the sql server databases?
Avatar of elaw

ASKER

Version for ESX 3.0.2, 52542
Version for Virtual centre server 2.0.2
No backup for the database

If we reinstall the Virtual centre server and create a new database, would it have any issues for the running production VM's.  I know we will have to redefine the roles / permissions, resourece pools, etc.  If someone has done this before would know exact steps taken.  Paulsolov mentioned that he done the same thing.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of elaw

ASKER

We have not created.  This is the reason we are asking the details.